| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert to mm:ss to just seconds
How can I convert minutes:seconds (mm:ss) to just seconds in excel?
E.g. 01:00 to 60seconds, 02:00 to 120 seconds? Your help would be greatly appreciated. Cheers |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert to mm:ss to just seconds
Hi!
Multiply by 86400 and format as GENERAL. =A1*86400 Biff "Jack" wrote in message ... How can I convert minutes:seconds (mm:ss) to just seconds in excel? E.g. 01:00 to 60seconds, 02:00 to 120 seconds? Your help would be greatly appreciated. Cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what is the formula to convert time (3:46) to total seconds? | Excel Worksheet Functions | |||
| how to convert whole numbers representing seconds to mm:ss | Excel Worksheet Functions | |||
| Create a custom format to convert seconds to minutes. | Excel Discussion (Misc queries) | |||
| How do I convert 00:03:54 to get 234 seconds? | Excel Worksheet Functions | |||
| convert seconds to minutes and seconds | Excel Worksheet Functions | |||
Linear Mode
