convert duration (hr:mn:sec) in to equivalent sec

P

pg

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.
 
B

Biff

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
 
P

pg

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 said:
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 said:
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.
Click to expand...
Click to expand...
 
Top