Thursday, January 2, 2014

Convert hh:mm:ss to seconds in Excel

If you have a field with a time in hours : minutes : seconds format and would like to convert that to a more usable format try the following formula.  Worked for me.
=(hours(A1)*3600)+(minutes(A1)*60)+(seconds(A1))

No comments:

Post a Comment