Swade730
03-19-2013, 03:49 PM
I was trouble shooting my spreadsheet today at work and from 8:30 am through to 12:59 PM everything looked good.
I was confident it was working but then 1:00 Pm kept reflecting as 1:00 AM
Then in trying to correct it to PM, the Cell showed 1:00 pm as 13:00 pm (military time)
Is there an easy way to adjust it so excel recognizes 1:00 as PM
its weird because 12:00 is recognized as Pm and then at 1:00 it jumps to 1:00 AM I have tried formatting but still no go!
I was confident it was working but then 1:00 Pm kept reflecting as 1:00 AM
Then in trying to correct it to PM, the Cell showed 1:00 pm as 13:00 pm (military time)
Is there an easy way to adjust it so excel recognizes 1:00 as PM
its weird because 12:00 is recognized as Pm and then at 1:00 it jumps to 1:00 AM I have tried formatting but still no go!