Display time format

[Guest]

I'm making a schedule where I am calculating time differences between cells.
In order to have the difference calculated correctly, I need to us h:mm AM/PM
or h:mm on 24 hour clock.

I need to display on the spreadsheet the 12 hour clock value without the
AM/PM being displayed in the field.

Is there a way to either:

1. Use the 12 hour clock format without the AM/PM showing

or

2. Use the 24 hour clock, but have the display convert to 12 hour without
the AM/PM?

Thank you,

 

[Earl Kiosterud]

Shane,

The AM/PM is a display-only issue, controlled by the cell formatting. Use Format - Cells -
Number - Date to change whether it shows the AM/PM part or not. Take a look at Format -
Cells - Number tab - Custom to see the format code in effect.

All times internally "know" if they're AM or PM, regardless of formatting (how they appear).
It's automatically a 24-hour clock. 3:00 AM is represented with a value of 0.125,
regardless of formatting. 3:00 PM is represented as 0.625.

Chip Pearson has a lot of info about how dates and times are handled in Excel.
www.cpearson.com.
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...