Add hours to date

  • Thread starter Thread starter Robert
  • Start date Start date
R

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
 
Another option:

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

Now the formula in A3 can be simply:

= A1+A2
 
Back
Top