Combined date time cell to separate date & time components

Combined date time cell to separate date & time components

Post by TWFyayBBZG » Fri, 03 Dec 2004 08:57:16


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)
 
 
 

Combined date time cell to separate date & time components

Post by TWFyayBBZG » Fri, 03 Dec 2004 08:59:04

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)

 
 
 

Combined date time cell to separate date & time components

Post by JE McGimps » Fri, 03 Dec 2004 09:07:17

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://www.yqcomputer.com/ :*excel*

See

http://www.yqcomputer.com/

for tips on using these groups effectively.





In article < XXXX@XXXXX.COM >,
 
 
 

Combined date time cell to separate date & time components

Post by JE McGimps » Fri, 03 Dec 2004 09:07:31

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://www.yqcomputer.com/ :*excel*

See

http://www.yqcomputer.com/

for tips on using these groups effectively.

In article < XXXX@XXXXX.COM >,
 
 
 

Combined date time cell to separate date & time components

Post by TWFyayBBZG » Fri, 03 Dec 2004 11:35:02

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)
 
 
 

Combined date time cell to separate date & time components

Post by JE McGimps » Fri, 03 Dec 2004 11:48:42

Please look for the previous answers you've gotten, including at least 2
to your identical post yesterday.


In article < XXXX@XXXXX.COM >,