Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i got a second counter wich basicly is a date: and each seconde since 1904 1st january it's adding up
there is the solution for unix (seconds since 1970) :
=Timestamp(([SecondSince1970]/86400)+25569)
Output is here:
06/02/2017 09:58:56 PM
i don't understand how i convert the underlined parameter do it work for seconds 1904.
the divided by 86400 convert the seconds into days, but the 25569 ... i don't get it
help thx
Just try: =Timestamp(([SecondSince1904]/86400)+1462)
- Marcus