Add hours to date

[Robert]

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

 

[Niek Otten]

Hi Robert,

In A3:

=A1+(A2/24)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[redbelly]

Another option:

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

Now the formula in A3 can be simply:

= A1+A2