View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
shane shane is offline
external usenet poster
 
Posts: 72
Default Display time format

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,