Entering Military Time

[Karen]

I have a spreadsheet where I enter military time. I entered 24:00 and the
cell displayed 0:00. Is there a format I could use so the cell displays 24:00?

Any help would be greatly appreciated, Karen

 

[Bernie Deitrick]

No. 24:00 doesn't exist in Military time - it is, essentially, the same as Midnight (0:00) of the
next day.

HTH,
Bernie
MS Excel MVP

 

[Karen]

Thank you!

No. 24:00 doesn't exist in Military time - it is, essentially, the same as Midnight (0:00) of the
next day.

HTH,
Bernie
MS Excel MVP

 

[xlmate]

Karen

You can format this by

select on the cells
right click
select Format Cells
In Number tab > select Custom
Under Type >> type in [h]:mm
click OK


Does this do what you want?

cheers

 

[Glenn]

I have a spreadsheet where I enter military time. I entered 24:00 and the
cell displayed 0:00. Is there a format I could use so the cell displays 24:00?

Any help would be greatly appreciated, Karen

Number format:

[h]:mm

 

[Shane Devenshire]

Hi,

Although Excel displays 24:00 as 0:00 on the Formula Bar you will see that
it is 12:00 AM. The key is the format you choose

Depending on exactly what you want you can use any of the following format:

[h]
[h]:mm
[h]:mm:ss
[h]:mm:ss.00

 

[Fred Smith]

You can use the following to display 24:00 when it's entered as such:

[=1]"24:00";hh:mm

Regards,
Fred.

 

[Karen]

Thank you!

You can use the following to display 24:00 when it's entered as such:

[=1]"24:00";hh:mm

Regards,
Fred.

I have a spreadsheet where I enter military time. I entered 24:00 and the
cell displayed 0:00. Is there a format I could use so the cell displays
24:00?

Any help would be greatly appreciated, Karen

 

[Karen]

Thank you!

I have a spreadsheet where I enter military time. I entered 24:00 and the
cell displayed 0:00. Is there a format I could use so the cell displays 24:00?

Any help would be greatly appreciated, Karen

Number format:

[h]:mm

 

[Karen]

Thank you!

Karen

You can format this by

select on the cells
right click
select Format Cells
In Number tab > select Custom
Under Type >> type in [h]:mm
click OK


Does this do what you want?

cheers

I have a spreadsheet where I enter military time. I entered 24:00 and the
cell displayed 0:00. Is there a format I could use so the cell displays 24:00?

Any help would be greatly appreciated, Karen

 

[Karen]

Thank you!

Hi,

Although Excel displays 24:00 as 0:00 on the Formula Bar you will see that
it is 12:00 AM. The key is the format you choose

Depending on exactly what you want you can use any of the following format:

[h]
[h]:mm
[h]:mm:ss
[h]:mm:ss.00

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

Thank you!