split combined Time Date cells
 

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)

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)

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)