Add Hours into Time

HomeExcel FormulasAdd Hours into Time

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

cell-with-time-value

Formula to Add Hours in a Time

Following steps that you can use add an hour in a time:

  1. First, refer to the cell where you have a time value that’s A1 our example.
  2. After that, enter a sum operator and starting parentheses.
  3. Next, enter the hour value that you want to add to the original time.
  4. Now, enter a division operator and type 24 which is the total number of hours that we have in a day.
  5. In the end, type closing-parentheses and hit enter to get the result value.
formula-to-add-hours

=A1+(3/24)

So, 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 into a time value. You can see this in the following formula.

time-function-to-add-time

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.

time-function-with-hour-argument

=A1+TIME(3,0,0)

🔙 Excel Formulas