Thread
:
Time Stamp to seconds
View Single Post
06-15-2021, 03:07 AM
Guessed
Windows 10
Office 2016
Expert
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,980
In Excel, the formula would be
="1:03:23"*24*60*60
In VBA there might be easier ways to do it but this appears to work
Code:
Dim sTime as string sTime = "1:03:23" Hour(sTime)*3600+Minute(sTime)*60+Second(sTime)
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Guessed
View Public Profile
Visit Guessed's homepage!
Find all posts by Guessed