Date-Time Stamp

[hansjhamm]

I am having to break down a date and time format into separate date
column & time column...

The data comes in this format: 9/25/06 16:59
But when I do text to columns and then re-format etc...this original
data comes out this way:
9/25/2006 and 4:59 AM. It should be 9/25/2006 and 4:59 PM.
How do I force this to accept the correct time. This only happens with
PM time.

Thanks,

Hans

 

[Guest]

Well, 16:59 is formatted as military (24-hour) time. It sounds like your
format conversion converts 16:59 to 4:59 without AM or PM markers. In the
absence of instructions on whether to consider 4:59 as being AM or PM, Excel
uses the default of 4:59 AM.

So the trick is to apply the correct format for the time. Try the format
h:mm AM/PM

Dave