Entering time in spread sheet and it reflects as military time.

I am in the process of creating a time in and out sheet in excel and I format everything to H:mm I use the mod function to subtract the times and I use a divisor of .5

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 and without military?

any help would be much appreciated.

Hi SWade,

You can Format - Cells - Time - *1:30:55 on the sheet itself or you can use VBA:

Please Login or Register  to view this content.