Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
from file dump have combined date time cells eg "14/04/03 14:20" (value
37725.59722). Want to perform time analysis so need to split to 2 separate cells; eg. "14/04/2003" (value 37725) & "14:20" (value 0.59722). Is there a fnc to do this? (Currently convert cell to value, then fncs trunc & cell less int(cell) then refmt to date dd/mm/yy & time hh:mm respectively) |
#2
![]() |
|||
|
|||
![]()
Hi Mark,
With your date/time in A1, B1= Int(A1) Format as date C1=A1-Int(A1) Format as time Drag the formulae down as far as required. --- Regards, Norman "Mark Ada" <Mark wrote in message ... from file dump have combined date time cells eg "14/04/03 14:20" (value 37725.59722). Want to perform time analysis so need to split to 2 separate cells; eg. "14/04/2003" (value 37725) & "14:20" (value 0.59722). Is there a fnc to do this? (Currently convert cell to value, then fncs trunc & cell less int(cell) then refmt to date dd/mm/yy & time hh:mm respectively) |
#3
![]() |
|||
|
|||
![]()
Hi Mark,
Sorry, I miised your currently convert ... line! --- Regards, Norman "Norman Jones" wrote in message ... Hi Mark, With your date/time in A1, B1= Int(A1) Format as date C1=A1-Int(A1) Format as time Drag the formulae down as far as required. --- Regards, Norman "Mark Ada" <Mark wrote in message ... from file dump have combined date time cells eg "14/04/03 14:20" (value 37725.59722). Want to perform time analysis so need to split to 2 separate cells; eg. "14/04/2003" (value 37725) & "14:20" (value 0.59722). Is there a fnc to do this? (Currently convert cell to value, then fncs trunc & cell less int(cell) then refmt to date dd/mm/yy & time hh:mm respectively) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Date and Time Macro | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |