To add an hour value into a time value in Excel, you can use a simple and short formula where you need to specify the original time from a cell and the hour(s) value that you want to add after dividing it by the 24 (which are totals hours that we have in a day).
In the following example, we have a time value in cell A1 (12:01 AM). And here you need to add 3 hours
Formula to Add Hours in a Time
Following steps that you can use to add an hour in a time:
- First, refer to the cell where you have the time value (that’s A1 our example).
- After that, enter the sum operator and type the starting parentheses.
- Next, enter the hour value you want to add to the original time.
- Now, enter a division operator and type 24 which is the total number of hours that you have in a day.
- In the end, type closing parentheses and hit enter to get the result value.
=A1+(3/24)The formula is quite simple. You just need to specify the original time hour value (divide it by 24).
Use Time Function to Add Time
You can also use the time function to add an hour to a time value. You can see this in the following formula.
You need to specify the original time, use the time function, and only specify the hour argument with the hours that you want to add.
=A1+TIME(3,0,0)