Conversion from Unix time to calendar date and time
Posted by Ehsan-Ur-Rehmann on September 18, 2001 4:37 AM
Hello, I want to convert evtdate ( Number of seconds from 1st of january 1970 to present time) to any date format.For example : Unix time 994632847 to DDMMYYYY and time hh:mm:ss
These unix dates are recorded in Excel worksheet and should be recorded in another worksheet after conversion.
Can somebody send me a Macro for this conversion.Thanks in advance.
Posted by Mark W. on September 18, 2001 8:22 AM
I'm not familiar with evtdate, but based on what
you've described...
=A1/86400+"1/1/70 where A1 contains your evtdate value
Can you provide a evtdate value and its corresponding
date so I can validate this formula?
Posted by Mark W. on September 18, 2001 8:23 AM
Typo correction...
=A1/86400+"1/1/70"
...didn't type the closing quote!
Posted by Artur on April 20, 2005 8:20 AM
Unix Time Formula
I have located non tested Unix conversion formula at your site. Below is the tested formula: =M19/86400+25569+0.416666666666667 25569 corresponds to 1/1/1970. 0.41666... corresponds to the time zone, in my case +10 hours in Melbourne, Australia example: 1113976018 translates to 20/04/2005 15:46:58
