View Single Post
  #3   Report Post  
Je
 
Posts: n/a
Default

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.

"Harald Staff" wrote:

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

HTH. Best wishes Harald

"jeff excel" <jeff skrev i melding
...
I am trying to convert a time 1:34:40 to strickly seconds. Is there a
formula that converts this.