Change satellite julian date format YYYYDDDHHMMSS to excel date ti

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.
 
G

Gary''s Student

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Three Digit Julian Date 4
convert Julian date to DD/MM/YYYY 7
Convert julian date 14
How to Convert a Julian Date to Calendar Date 2
convert Julian Date Format to Excel 1
how to convert from julian date to mm/dd/year 6
julian date 1
Formula to show when the julian date changes 1

Top