Change satellite julian date format YYYYDDDHHMMSS to excel date ti

  • Thread starter Thread starter putley
  • Start date Start date
P

putley

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.
 
=DATE(LEFT(A1,4),1,MID(A1,5,3))+TIME(MID(A1,8,2),MID(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
 
Back
Top