| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel hh:mm format
In some worksheets, a cell formatted hh:mm with a value of 24 will yield the
desired result - 24:00 (24 hours). As of today some worksheets are yielding 00:00 for the same value of 24, and in the formula bar, you can see that the 24 has been converted to 1/24/1900 12:00:00AM - the 24th day of the century. How can this be corrected so that it will show 24 hours. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to format cells in Excel 2007 (i.e. currency format)? | Excel Discussion (Misc queries) | |||
| Convert Excel 2007 format (*.xlsx) into Excel 2003 format | Excel Discussion (Misc queries) | |||
| Excel Auto-Format cell to email format | Excel Discussion (Misc queries) | |||
| How to covert picture excel format to editable excel format | Excel Discussion (Misc queries) | |||
| how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
Threaded Mode
