Entering Military Time
 

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

Entering Military Time
 

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" wrote in message
...
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

Entering Military Time
 

Thank you!

"Bernie Deitrick" wrote:

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" wrote in message
...
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

Entering Military Time
 

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


"Karen" wrote:

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

Entering Military Time
 

Karen wrote:
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

Entering Military Time
 

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


"Karen" wrote:

Thank you!

"Bernie Deitrick" wrote:

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" wrote in message
...
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

Entering Military Time
 

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

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

Regards,
Fred.

"Karen" wrote in message
...
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

Entering Military Time
 

Thank you!

"Fred Smith" wrote:

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

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

Regards,
Fred.

"Karen" wrote in message
...
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

Entering Military Time
 

Thank you!

"Glenn" wrote:

Karen wrote:
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

Entering Military Time
 

Thank you!

"xlmate" wrote:

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


"Karen" wrote:

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

Entering Military Time
 

Thank you!

"Shane Devenshire" wrote:

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


"Karen" wrote:

Thank you!

"Bernie Deitrick" wrote:

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" wrote in message
...
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