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))
No comments:
Post a Comment