Add hours to date

Hello,

Can someone help me with the following issue?

What I am trying to do is add an amount of hours to a specific date, for example:

Cell A1: 15/03/2005 22:00 (dd/mm/yyyy hh:mm)
Cell A2: 5 (hours)
Cell A3: A1 + A2 (Result: 16/03/2005 03:00)

I'm curious what formula to use!

Thanx in advance!

Rgds,
Robert

Hi Robert,

In A3:

=A1+(A2/24)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Robert" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> Can someone help me with the following issue?
>
> What I am trying to do is add an amount of hours to a specific date, for
> example:
>
> Cell A1: 15/03/2005 22:00 (dd/mm/yyyy hh:mm)
> Cell A2: 5 (hours)
> Cell A3: A1 + A2 (Result: 16/03/2005 03:00)
>
> I'm curious what formula to use!
>
> Thanx in advance!
>
> Rgds,
> Robert

Another option:

Enter the "5" in hours:min format, as "5:00"

Now the formula in A3 can be simply:

= A1+A2