How do I convert a time units

J

jeff excel

I am trying to convert a time 1:34:40 to strickly seconds. Is there a
formula that converts this.
 
H

Harald Staff

=A1*86400
format result cell as number (it will default to time and dislpay 0:00:00)

HTH. Best wishes Harald
 
J

Je

Sorry, I think I did not make my self clear. I want to take this time frame
1:34:40 and convert it to 5680 seconds. I am calculating race times and need
to break down the time it took an individual to race, (in this case 1 hour,
34 minutes & 40 seconds) and convert it to total seconds.
 
H

Harald Staff

Ah, I see. In that case
=A1*86400
format result cell as number (it will default to time and dislpay 0:00:00)

HTH. Best wishes Harald
 
Top