Excel add one hour

Question

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

User · Accepted Answer

A1 TIME 1 0 0    Although  maybe this should be posted on Super User

User · Answer

In cell A1  enter the time  In cell B2  enter  A1 1 24

User · Answer

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

[excel] Excel add one hour

Examples related to excel

Examples related to excel-2003