Thread: Time Stamp to seconds
View Single Post
 
Old 06-15-2021, 03:07 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
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
Reply With Quote