| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a formula that will convert h:mm:ss into seconds?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a formula that will convert h:mm:ss into seconds?
A formula:
Since XL stores times as fractional days, you can multiply by the number of seconds in a day: =A1*86400 If you only want to display seconds, you can use Format/Cells/Number/Custom [s] (the brackets prevent roll-over to minutes & hours). In article , tsp wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| i need to convert seconds (ie: 17288.35111) into days, hours, min | Excel Discussion (Misc queries) | |||
| Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
| Create a custom format to convert seconds to minutes. | Excel Discussion (Misc queries) | |||
| How do you convert a formula cell to a constant cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
