| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
number formatting for time
I need to format a column to show only minutes and seconds in the 31:12
format. It must force the data to conform so the interns will not screw up the table. I have tried all the options with none working. The format [h]:mm works but the formula bar shows 1/1/1900 6:24:00 AM for the time 30:24 Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with time formatting | Excel Discussion (Misc queries) | |||
| Convert time stored as decimalised number to time format | New Users to Excel | |||
| Every time i put a number with period it becomes a date and time | Excel Discussion (Misc queries) | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Threaded Mode
