Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Cells
I would like to change the format to show hours and minutes where the hours
are over 24. By going to the format list I see one that almost fits the bill but not quite. [h]:00:00. Is there a way to put in my own formula which would be [h]:00 as I don't want the seconds. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells | Excel Worksheet Functions | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Formatting cells | Excel Discussion (Misc queries) | |||
Formatting Cells | Excel Discussion (Misc queries) | |||
Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions |