Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Round/Display (HR:MN:SEC) data in decimal HR format for Time C | Excel Discussion (Misc queries) | |||
How do I display time in a negative format? | Excel Worksheet Functions | |||
display no seconds in time format [h] | Excel Discussion (Misc queries) | |||
I cannot get time format to display in a drop-down list | Excel Discussion (Misc queries) | |||
entering numbers to display a time format | Excel Discussion (Misc queries) |