Take a look at the answer you got yesterday to the same question.

If you didn't see the reply, after looking through the previous posts,
try searching the archives:

http://google.com/advanced_group_search?q=group:*excel*

using your name, email address, subject, or keywords in your post.


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)