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

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

--
HTH

Bob Phillips

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

"Charlie7805" <(E-Mail Removed)> wrote in message
news:4018C536-A036-4DE5-8FCB-(E-Mail Removed)...
> 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

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

--
HTH

Bob Phillips

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

"Charlie7805" <(E-Mail Removed)> wrote in message
news:4018C536-A036-4DE5-8FCB-(E-Mail Removed)...
> 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

Enter your date/time in D6 and format as required (in the UK it would
be dd/mm/yy hh:mm:ss). Enter this formula in E6:

=D6 + 140/24

and format E6 the same as D6 (you might want to miss the seconds off,
though)

Hope this helps.

Pete

Charlie7805 wrote:
> 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

Enter your date/time in D6 and format as required (in the UK it would
be dd/mm/yy hh:mm:ss). Enter this formula in E6:

=D6 + 140/24

and format E6 the same as D6 (you might want to miss the seconds off,
though)

Hope this helps.

Pete

Charlie7805 wrote:
> 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