This tutorial helps you to learn to add time. That means if you have a time value in a cell and want to add hours, minutes, and seconds to that time. And for this, we will learn three different formulas.
Add Hours to a Time
In the following example, you have a time value in cell A1 (10:30 PM), and now you need to add 1 hour.
Use the following steps:
- First, in cell B1, enter “=”.
- After that, refer to cell A1 where you have the original time, and
- Next, enter the “+” addition operator.
- Now, enter the TIME function. And in the hours argument, enter 1, and in the rest of the two arguments, enter zero (0).
- Finally, enter the closing parentheses and hit enter to get the new time after adding 1 hour.
=A1+TIME(1,0,0)
The moment you hit enter, it returns 11:30, 1 hour ahead of the original time.
Add Minutes to a Time
In the same way, if you want to add minutes to the time, you can use the below formula, which also uses the TIME function.
In this formula, we have 25 in a minute argument to add 25 minutes to the original time. And zero (0) for the rest of the two arguments (hour and second). And the moment you hit enter, it returns 10:55 PM, 25 minutes ahead of the original time.
Add Seconds to Time
And if you want to add seconds, add the seconds in the second argument.
=A1+TIME(0,0,50)
This way, you get the new time with 50 seconds in addition.
Make sure to change the time format from HH:MM to HH:MM:SS to see the seconds that you have in the time value.
Another Formula to Add Time (Hours, Minutes, and Seconds)
There’s another way to create a formula using the total number of hours, minutes, and seconds.
In a day, there are:
- 24 Hours
- 1440 Minutes
- 86400 Seconds
Now if you want to add:
- Hours: original_time + hours_to_add/total_hours_in_a_day
- Minutes: original_time + minutes_to_add/total_minutes_in_a_day
- Hours: original_time + seconds_to_add/total_second_in_a_day