In converting Hours:Mins:seconds to seconds I was always a beleiver of using =(HOUR($A1)*3600)+(MINUTE($A1)*60)+(SECOND($A1)) but recently discovered that Excel stores times greater than 24 hours as days/months/years/hours/minutes/seconds
To get around this problem paste the following into a module:
Public Function TSITSeconds(CellName) As String
Dim Result, TotResult As String
Dim newname As Integer
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.