If the Julian date is in column B and the Hour/Minute in column C, the
following formula will convert these two into a "decimal date". For
example Julian day 303 at 0000 will be 303.0000, while 12:00 will be
303.5000, etc. Use of the time in this format will facilitate plotting
time series. (Cut and past this formula into excel)
=B1+(TRUNC(C1/100)/24) + (C1 - TRUNC(C1/100)*100)/(24*60)
| |_ this part separates the |_ this part separates the
| hour from the minutes and minute from the hour and adds
| adds its contribution to the minutes contribution to the
| the time time.
|_ this part just adds in the julian day