Converting minutes & seconds to total seconds

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

Guest

Is there an easy way to put h:mm:ss into a cell, and then have it convert to total seconds in another cell

This is for the purpose of scoring competition teams, I'd like my sheet to show the total minutes & seconds for the team to complete their event. But for scoring purposes, since the lowest time is actually the winner, I need to have the total number of seconds to convert the time score to a point system.

Thanks
Ginny
 
XL stores times as fractional days, so to get seconds, multiply by 24 x
60 x 60:

If A1 has the time,

A2: =A1 * 86400
 
Hi
one way:
=A1*24*60*60
and format this cell as 'Number'

or use
=A1
AND format your cell with the custom format
[ss]
 
Back
Top