# How to Add Hours into Time in Excel

- Written by Puneet

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). The following example shows 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:

1. First, refer to the cell where you have the time value (A1 in our example).
2. After that, enter the sum operator and type the starting parentheses.
3. Next, enter the hour value you want to add to the original time.
4. Now, enter a division operator and type 24, the total number of daily hours.
5. Finally, type closing parentheses and hit enter to get the result value.
``=A1+(3/24)``

The formula is quite simple. You must 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 you want to add.

``````=A1+TIME(3,0,0)