View Single Post
  #2   Report Post  
Biff
 
Posts: n/a
Default

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.