| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
convert to seconds
Anyone know how to convert a time (format= HH:MM:SS) into seconds? example:
1:10:05 = 4205 |
|
#2
|
|||
|
|||
|
XL stores times as fractional days, so you need to multiply the time by
24*60*60, or =A1 * 86400 In article , Arturo wrote: Anyone know how to convert a time (format= HH:MM:SS) into seconds? example: 1:10:05 = 4205 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i convert a number of seconds to a date/time? | Excel Worksheet Functions | |||
| Convert seconds to minutes and seconds in excel | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| convert seconds to minutes and seconds | Excel Worksheet Functions | |||
| Minutes to seconds - how to convert? | Excel Worksheet Functions | |||
Linear Mode
