Thread
:
split combined Time Date cells
View Single Post
#
2
Norman Jones
Posts: n/a
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 With Quote