Converting minutes & seconds to total seconds

[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

 

[JE McGimpsey]

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

 

[Frank Kabel]

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]

 

[Guest]

It seems it was a formatting problem all along, it's working great!
Thank you, thank you!