How to get seconds since epoch (1/1/1970) in VBA?

vba time epoch seconds
aF. picture aF. · Feb 13, 2010 · Viewed 26.2k times · Source

How can I get seconds since epoch (1/1/1970) in VBA?

Answer

Fionnuala picture Fionnuala · Feb 14, 2010

How about:

datediff("s",#1970/1/1#,now())

Related questions

Display milliseconds in Excel

I am trying to display milliseconds in an Excel macro. I have a column of integers which are timestamps in milliseconds (e.g. 28095200 is 7:48:15.200 am), and I want to make a new column next to it which keeps a running …

Read More
Convert decimal number to minutes and seconds using VBA

I have time represented by a decimal number that I need to convert to minutes and seconds in Excel using VBA. Example: The number before the decimal point gives the minutes as 0.197683577 (0 minutes) and the number multiplied by 60 gives the …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More