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.

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.

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.