| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
convert duration (hr:mn:sec) in to equivalent sec
I have excel 2002. I want to convert duration (hr:mn:sec) in to equivalent
seconds. How do I acheive it? The duration (hr:mn:sec) is given in one cell. |
|
#2
|
|||
|
|||
|
Hi!
Just multiply by 86400: A1 = 10:12:05 B1 = A1*86400 Format the cell as GENERAL OR, just format cell A1 as :[ss] Biff "pg" wrote in message ... I have excel 2002. I want to convert duration (hr:mn:sec) in to equivalent seconds. How do I acheive it? The duration (hr:mn:sec) is given in one cell. |
|
#3
|
|||
|
|||
|
Dear Biff,
Thank you very much for your help, very much appreciated. But I wonder why it is not listed in MS help for excel? "Biff" wrote: Hi! Just multiply by 86400: A1 = 10:12:05 B1 = A1*86400 Format the cell as GENERAL OR, just format cell A1 as :[ss] Biff "pg" wrote in message ... I have excel 2002. I want to convert duration (hr:mn:sec) in to equivalent seconds. How do I acheive it? The duration (hr:mn:sec) is given in one cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
| Improve Convert function in Excel | Excel Worksheet Functions | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| How do I convert a time eg. 00:01:39 to a duration eg. 1.65 min o. | Excel Worksheet Functions | |||
Linear Mode
