Combined date time cell to separate date & time components
 

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)

See the reply to your post in the microsoft.public.excel newsgroup.

Please don't post the same question to multiple groups. It just wastes
the time of those replying to a question that was already answered, and
fragments your answers.

In your case, this question was answered yesterday when you posted the
same question. Look in the archives:

http://groups.google.com/advanced_gr...=group:*excel*

See

http://cpearson.com/excel/newposte.htm

for tips on using these groups effectively.

In article ,
"Mark Ada" wrote:

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)