Date and time calculations

[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

 

[Dave Peterson]

=a1+(a2/24)

Format the way you like. (5 hours is 5/24ths of a day.)

 

[Wild Jim]

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.