Adding hours to a date and time

R

Rich

I want to add a number of hours to a date and a time and have Excel give me
the resulting date and time. For example:

1st Dec 2004 13:00

Add 48 hours

Result: 3rd Dec 2004 13:00

What is the formula that I need for this?
 
R

Rich

Thanks for that. The hours that I will want to add to the date could be
anything, including part days, eg 3.25 hours, 92.4 hours, and so on. Can I
add the hours to the date and time and it give me the resulting date and time
without me having to divide by 24 (eg 1 day)?

Richard
 
H

Harald Staff

One hour is 1/24 so that's what you must deal with. But I assume you'll put
it in a formula so with datetime in A1 and Hours to add in B1, formula in C1
reads
=A1+B1/24
and you enter just your decimal number.

HTH. best wishes Harald
 
R

Rich

That's great, thanks for the help.

Harald Staff said:
One hour is 1/24 so that's what you must deal with. But I assume you'll put
it in a formula so with datetime in A1 and Hours to add in B1, formula in C1
reads
=A1+B1/24
and you enter just your decimal number.

HTH. best wishes Harald
Click to expand...
 
Top