SharePointers
SharePoint tips and tricks from a SharePoint developer
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))
Newer Posts
Older Posts
Home
Subscribe to:
Comments (Atom)