Curtis,

It adds a day for me. With an 8 in cell E6 of "5 minute", I get
Jan 8, 2006 and 00:46:10
Which is tomorrow, 8 hours from now (now being Jan 7, 2006, 16:46:10).

You might want to make sure that there is only one value filled in E6 _or_
E7.

HTH,
Bernie
MS Excel MVP


"ffzeus" wrote in message
...
Hi Bernie,

Sorry to bother again, I noticed that the day field does not add a day if
the time crosses midnight with the addition of the GMT offset from E6 and
E7.
Can you tell me how to add this?

Thank you.

Curtis Z