=INT(A2) gives the date.
=MOD(A2,1) gives the time.
Format the cells appropriately.

If you are doing time calculations and you want to display a total which is
more than 24 hours, format as [hh]:mm:ss, not hh:mm:ss
--
David Biddulph

"Sean" wrote in message
...
Hello, I am trying to take the date in the format of mm/dd/yyyy hh/mm/ss
and
on another worksheet creat a summary which would have a date field, a
seperate start time field, a seperate end time field, and a total time
field.
Any suggestions as to the formulas that might help me out?

Thanks