Julian conversion

I am wondering if anyone has written a macro or has developed a formula that will convert a Julian time into a more understandable format? Thanks in advance.

S4E

What exactly do you mean?

Can't you just use formatting to show the time as you want?

I assume by julian date you mean the number of the day within the year
1 to 365 (non leap year)

eg. J 32 is 1 Feb 2005

There are two conventions for this on a leap year
one is 29 Feb is J 366
the other easier to handle version is
29 Feb is 60 and 31 Dec becomes J 366

The second convention allow you to add the Julian date onto the last date of the previous year to get the date in this year

eg. =A1 + Datevalue("31 Dec 2004)

formated as Date

Hope this helps RES

Originally Posted by Norie

What exactly do you mean?

Can't you just use formatting to show the time as you want?

One of the fields in the database that I am querying is displayed in seconds based on the Julian date starting on 1/1/1970 (e.g. 1107773696). I am trying to convert this field into a more readable format (e.g. 13:30:55).

S4E

I was able to locate a formula that converts the seconds into date (25569+(T/86400)-(5/24)).

T=the number of seconds since 1/1/1970.

5/24=sets time to EST.

Thanks for your assistance.

Glad you found a solution.

By the way do you actually mean Gregorian rather than Julian.

I thought the convention these days (and for a few centuries) has been to use the Gregorian calendar.