Split combined date time data
 

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)

Mark,

It seems that =INT(A2) and =MOD(A2, 1), suitably time or date formatted,
would be the ticket. But it seems that's what you're already doing, and
want something else.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Mark Ada" 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)