[excel] Excel add one hour

I have in cel A1 with the following contents:

7:30:43 which is a time.

But now i want to use a formula to add one hour. What is the best way or how can i do this?

This question is related to excel excel-2003

The answer is


This may help you as well. This is a conditional statement that will fill the cell with a default date if it is empty but will subtract one hour if it is a valid date/time and put it into the cell.

=IF((Sheet1!C4)="",DATE(1999,1,1),Sheet1!C4-TIME(1,0,0))

You can also substitute TIME with DATE to add or subtract a date or time.


In cell A1, enter the time.
In cell B2, enter =A1+1/24