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
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
Source: Stackoverflow.com