Time Stamp to seconds

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Time Stamp to seconds

06-15-2021, 03:07 AM

Guessed

Windows 10 Time Stamp to seconds

Office 2016

Expert

Join Date: Mar 2010

Location: Canberra/Melbourne Australia

Posts: 4,176

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Eliminate time stamp in Track Changes	Aden	Word	19	07-10-2023 09:02 PM
Time Stamp Incorrect	ashippen	Outlook	0	06-27-2016 12:04 PM
Time Stamp for Categories?	mlef	Outlook	0	05-18-2016 09:46 AM
Date & time stamp problems in Word XP	Scotfan	Word	3	03-09-2016 09:45 AM
Updating time stamp only when changes have been made and re-saved	ashmo0024	Word	1	09-05-2014 01:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:10 AM.