Date & Time Field

D

Diane Walker

I am running Excel 2003. I have a field that combines both date and time
(MM/DD/YYYY HH:MM:SS AM or PM). I would like to know if there is a way
break this field into a date field (MM/DD/YYYY) and a time field (HH:MM).

Thanks.
 
R

Roger Govier

Hi Diane

For Date = INT(A1) format as a suitable Date format
For Time =MOD(A1,1) format as hh:mm
 
Top