To convert a time (hh:mm:ss) in Excel
To convert a time (hh:mm:ss) in Excel, it may be easiest to multiply the cell by 86,400 which is the number of seconds in a 24 hour period.
eg: 2:15:05 would become 8,105
and 0:01:05 would become 65.
Change the cell format from the time format to this custom format [s].0
Another option is to use the MINUTE and SECOND functions.
This will convert time such as 2:15:05 in cell A1, to the total value in seconds.
1,157.1 - 571,473