Unix time to Excel formula not working

Topic

New Reply

I find many sites saying to use the following formula to convert a Unix data/time format to Excel date. =(A1/86400)+25569+(-9/24) where A1 contains the Unix time. I’m getting this time from another system and the example I’m using in A1 is 1461336955311. Excel says the resultant date is negative or too large to display. Suggestions for troubleshooting appreciated.

Reply | Quote

Replies

Hi bdesilva,

Please check the value you are using as the Unix Date:
1461336955311

If you truncate the value to
1461336955

Your date will evaluate to 04/22/2016 5:55 using your formula.

HTH,
Maud

Reply | Quote

Forgot to mention that I formatted the cell with the formula as:

mm/dd/yyyy h:mm

Reply | Quote

Forgot to mention that I formatted the cell with the formula as:

mm/dd/yyyy h:mm

and I assume that you want to use a 9 hour offset from GMT.

Maud

Reply | Quote

Thanks! That solved it.

Reply | Quote