You could use your intermediate variables:

dDateTime = DateSerial(jyear, jmonth, jday) + _
TimeSerial(jhour, 0, 0)

But that seems to be the long way round when you only have to do a
subtraction. Both julian and XL dates are integer offsets from a base
date with time being represented as a fractional day. You need only
subtract the difference in base dates from the jd to get the XL date.

Why bother with additional variables and function?


In article <TnTZb.33632$4o.50339@attbi_s52, "Pal"
wrote:

Thanks but I am not sure what you are doing here.

I thought I needed to convert my Jyear, Jmonth, Jday, Jhour into a
MM/DD/YYYY HH:MM format.
I tried adding them directly and displaying them in that format but it did
not work.