Hi Diane

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

--
Regards

Roger Govier


"Diane Walker" wrote in message
...
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.