Display standard time without "AM or PM" while entering in military time

2

23shun

Hello,

I am creating a time sheet. Any help would be appreciated.
I have 4 cells:
1. IN (time cell)
2. OUT ( time cell)
3. Lunch (time cell)
4. Total Hrs(number cell)

When I enter in military such as 16:30 I would like it to display 4:3
withou the "PM or AM"
I have tried the format (h:mm) and custom options and have bee
unable to display as "00:00".

Can you please help.
Thank yo
 
F

Frank Stone

Yes. create or modify your own format.
go to Format>cells>number>custom.
modify - scroll down to a format h:mm and high light it.
it will appear in the text box above the combo
box. edit h:mm to hh:mm.
create - once to the custom tab, enter the new format. both
formats(h:mm and hh:mm) will be available.
 
2

23shun

I have tried the tip the time is displayed in military time

I have gone to format>custom>hh:mm

Military time stays as military time and does not display as standar
time

Is there a different way of doing this
 
D

Dave Peterson

If it's for display only, I'd use a helper cell with this formula in it:

=LEFT(TEXT(A1,"hh:mm AM/PM"),5)

But don't try to do date/time arithmetic with it--it's text.

Use the original cells (formatted hh:mm) for all your calculations.
 
Top