ExcelBanter - How do i convert unix time to Julian time in excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do i convert unix time to Julian time in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/122709-how-do-i-convert-unix-time-julian-time-excel.html)

Ken

How do i convert unix time to Julian time in excel?

I have a logging device that reports the time in "unix time."
Is there a formula that will do this?

Bob Phillips

How do i convert unix time to Julian time in excel?

=DATE(1970,1,1)+A1/60/60/24

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

"Ken" wrote in message
...
I have a logging device that reports the time in "unix time."
Is there a formula that will do this?

All times are GMT +1. The time now is 02:00 AM.