Unix time is merely the number of seconds since 01 Jan 1970 00:00 UTC
Excel time is expressed in decimal days.
There are 86,400 seconds in a day.
So to convert a Unix timestamp to XL time
=UnixTime/86400+DATE(1970,1,1)
Format to something you like.
Correct of the difference between UTC and your time zone if you want.
--ron
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.