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?
Solution 1:
=A1+TIME(1,0,0)
Although, maybe this should be posted on Super User.
Solution 2:
In cell A1, enter the time.
In cell B2, enter =A1+1/24