| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Standard Time to Military Time in Excel | Excel Discussion (Misc queries) | |||
| formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
| Converting Standard Time into Military Time | Excel Discussion (Misc queries) | |||
| Show timesheet time in and out in regular time versus military tim | Excel Worksheet Functions | |||
| Military Time | Excel Worksheet Functions | |||
Linear Mode
