Date & Time Field

  • Thread starter Thread starter Diane Walker
  • Start date Start date
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.
 
Hi Diane

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date 1
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 2
How to customize =Now() 11
Dates in Excel 2003 1
Date and Time (entering in the format of mm/dd/yyyy and hh:mm:ss ) 8
Formatting Dates from Text to Numbers 2
Separating Date and Time 4
Excel 2002: How to make the date format uniform ? 1

Back
Top