| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
number formatting for time
Thanks, I appreciate all your help.
"Tom Ogilvy" wrote: you can enter 30:24 and it will be stored as hours, but you can mentally treat it as minutes. Don't look at the formula bar it if bothers you. If you do addition, you will be adding hours, but formatting the cell as [hh]:mm will still "look" like total minutes. -- Regards, Tom Ogilvy "G Henry" wrote: Thanks, But we never need hours, just minutes and seconds. We are a radio staion and this is FCC mandated informaiton so 55 minutes is the longest. Any way to type in 30:24 and have it show 30 minutes and 24 seconds? "Tom Ogilvy" wrote: the format should be [mm]:ss if you entere 30:24, that is 30 hours 24 minutes. to enter 30 minutes and 24 seconds you must enter 0:30:34 or 00:30:24 Look at Data=Validation if you want to restrict entry. the is a Time option with parameters you can specify. -- Regards, Tom Ogilvy "G Henry" wrote: 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 | |||
![G Henry[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
