| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date format to Julian Date?? | Excel Discussion (Misc queries) | |||
| to convert a julian date back to regular date | Excel Worksheet Functions | |||
| Convert a julian gregorian date code into a regular date | Excel Worksheet Functions | |||
| how to convert julian date to general date | Excel Worksheet Functions | |||
| how to convert julian date to regular calendar date | Excel Worksheet Functions | |||
Hybrid Mode
