Change satellite julian date format YYYYDDDHHMMSS to excel date ti
 

In need an excel function to convert the julian date format commonly used for
satellites, YYYYDDDHHMMSS (DDD is julian day of year) to Excel date time
format.

Change satellite julian date format YYYYDDDHHMMSS to excel date ti
 

=DATE(LEFT(A1,4),1,MID(A1,5,3))+TIME(MID(A1,8,2),M ID(A1,10,2),RIGHT(A1,2))

and format the cell as Custom mm/dd/yyyy hh:mm:ss

For example if A1 contains 1999300020202
the formula returns: 10/27/1999 02:02:02

--
Gary''s Student - gsnu200765


"putley" wrote:

In need an excel function to convert the julian date format commonly used for
satellites, YYYYDDDHHMMSS (DDD is julian day of year) to Excel date time
format.