Adding hours to a date

Guest · Nov 23, 2004

Hi,

I want to add a number of hours to a date and a time and have Excel give me
the resulting date and time. 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.

For instance

1st Dec 2004 13:00

Add 50.5 hours

Result: 3rd Dec 2004 15:30

What is the formula that I need to achieve this?

Harald Staff · Nov 23, 2004

One hour is simply 1/24, so

=A1+92.4/24

HTH. best wishes Harald

JE McGimpsey · Nov 23, 2004

One way:

A1: 1 Dec 2004 13:00
A2: 50.5
A3: =A1 + A2/24

Format A3 as a Date/Time.

Opinicus · Nov 23, 2004

Harald Staff said:
One hour is simply 1/24, so
=A1+92.4/24

Thank you. That explains something that has puzzled me about
adding dates and times.

Adding hours to a date

Guest

Harald Staff

JE McGimpsey

Opinicus