| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, I want to convert Eastern time to pacific time | Excel Discussion (Misc queries) | |||
| How do I enter a time in excel so it does not print as 1:00:00 PM | New Users to Excel | |||
| Saving Excel files takes a huge amount of time | Excel Discussion (Misc queries) | |||
| Convert data into standard military time format | Excel Discussion (Misc queries) | |||
| How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
