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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert duration (hr:mn:sec) in to seconds 1
How do I convert seconds (up to 38,000) into HR:MN:SEC? 4
Adding minutes to hours/minutes 4
Convert Hrs:MM:SS to number of days 3
Duration stored as text 1
Calculating Time Spans 2
Subtracting a duration from a time to calculate a time. 5
adding up event durations? 1

Back
Top