=d6+5+TIME(20,0,0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Charlie7805" wrote in message
...
I'm looking for a simple formula to add 140 hours from a entered
data/time.
Example: In D6 a date/time is entered. In E6 140 hours is added giving
the
results in a new date/time format.

This is probably simple but having problems making it work. Also, how
would
these cells be formatted?

Thxs in advance