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.

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.

Thanks very much, Roger.

"Roger Govier" wrote in message
...
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.