Date and time calculations

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

Robert

Hello,

I have a problem with a formula in wich I like to add up an amount of
hours to a date/time value.

Please find below an example of what I am trying to do.

Value A1: 15/03/2005 22:00 (dd/mm/yyyy hh:mm)
Value A2: 5 (hours)
In cel A3 I would like to get the value of A1+A2 (result 16/03/2005
03:00)

Can someone suggest what formula I must use?

Thanx very much!
Robert
 
The formula you are using is correct, the error is in the cell with the 5
hours in it. - You can't just type 5 and expect excel to know it is hours -
if you type 5:0:0 in the cell, you should see your desired result.
 
Back
Top