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?
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 Name (required)
Your Email (required)
Enter the destination URL
Or link to existing content