Excel add one hour

I have in cel A1 with the followin开发者_如何学Cg 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?

---

=A1+TIME(1,0,0)

Although, maybe this should be posted on Super User.

---

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

---

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.