How to convert a 64 bit date to standard?

Q&A ForumHow to convert a 64 bit date to standard?
Guest Staff asked 2 years ago

I have a database that uses 64 bit format of date but need to convert it to standar dd/mm/yyyy hh:mm. How do I do that?

1 Answers
Francisco answered 2 years ago

Excel keeps track to the second (seconds, minutes, hours) and starts from 1970. Substitute A1 with your data to get your date.  =A1/(60*60*24)+”1/1/1970″

Afterwards you will be able to edit the cell to under Number to whatever format you need

Your Answer

16 + 10 =