software

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 Govierquot;Diane Walkerquot; gt; wrote in message
...
gt;I am running Excel 2003. I have a field that combines both date and
gt;time (MM/DD/YYYY HH:MM:SS AM or PM). I would like to know if there is
gt;a way break this field into a date field (MM/DD/YYYY) and a time field
gt;(HH:MM).
gt;
gt; Thanks.
gt;
gt;
Thanks very much, Roger.

quot;Roger Govierquot; gt; wrote in message
...
gt; Hi Diane
gt;
gt; For Date = INT(A1) format as a suitable Date format
gt; For Time =MOD(A1,1) format as hh:mm
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Diane Walkerquot; gt; wrote in message
gt; ...
gt;gt;I am running Excel 2003. I have a field that combines both date and time
gt;gt;(MM/DD/YYYY HH:MM:SS AM or PM). I would like to know if there is a way
gt;gt;break this field into a date field (MM/DD/YYYY) and a time field (HH:MM).
gt;gt;
gt;gt; Thanks.
gt;gt;
gt;gt;
gt;
gt;