 If you have worked with dates before, you must know how to add or subtract the dates, the benefit of adding the dates or the time is to calculate another time or data which is very useful you will see in this article. Just like dates, time can also be added, subtracted, multiplied, and even divided with other integers so that we can have important calculations within the time format. To add the time we don’t have complex functions or formulas to use, we simply need to understand the conceptualization behind the time in google sheets.

As we can do all the operations on dates very easily, because the dates do not have minutes or seconds, if we add 1 to 7/dec/2021 it will make it 8/dec/2021. But when we do the same with the time, we have to tell google sheets about minutes and seconds along with hours to get accurate results.

We often deal with timestamps in google sheets, we have to manage different kinds of datatypes like integers, strings, objects, formulas, links, XML, dates, and time. So we must know how to manipulate them and use them along with other data types, when we have timestamps coming from a source, for example, I have an online store and I am using some script to extract the order time on my store and the script automatically extract that timestamp into google sheets.

Now what if I have to alter the data and have to make small changes in the time extracted by the script. I will have to do manually to all the timestamps it will take a lot of time because the entries can be in hundreds or even in thousands and we don’t know if they can also be in millions, so we must know how to add time in google sheets.

• To add time with integer types.
• To make small changes in the time extracted by some kind of formula of the script.
• To see the before and after the time of the exact time

Here we will see what are the steps or methods required to learn how to add time in google sheets. We will understand the time theory in the google sheets and then we will move forward to the application and we will learn it practically.

### How to Add Time in Google Sheets – Understanding Time Format

Times do not work in the same way as dates. Adding an integer to a time let’s say 10:00 AM will be 10:00 AM, after adding a number let’s say 3, but when I add the same number 3 to a date, let’s say 07-12-2021, it will become 10-12-2021.

So, If 1 (as a day) is equal to 24 hours, then one hour is equal to 1 / 24, one minute is equal to 1 / (24*60), and similarly, one second is equal to 1 / (24*60*60)

Having said that I hope you guys have got the logic, this is the logic on which you can do anything with dates in google sheets

Let’s move on to see practical examples for various use cases of time in google sheets

I have a sample data set in which I have some timestamps in column A, and in column B I have some random numbers written as hours (in number format), I will add the timestamps with the numeric numbers and in column C you will see that the time has taken the given number of hours and now time is changed.

Step 1

Add sample data in column A Step 2

Add the random number of hours in column B Step 3

The addition formula in column C, will not return the correct answer  Step 4

To work on hours, we need to divide the formula with 24 Step 5 Step 6

Let’s experiment with other operations

Subtraction  Multiplication  Division  This is how you can work with hours and do all operations with the hours of the given timestamps

To add minutes we all have the same procedure just a change in the formula is to be made to make it work on minutes rather than hours.

Step 1

Further multiply the hours with minutes, as we divided by 24 to make hours, now further will multiply it by 60 to make minutes (as we have 24 hours in a day, then 60 minutes in an hour) Step 2

Hit enter and you’re done. you can verify it manually Step 3

Let’s experiment with other operations

Subtraction  Multiplication  Division  To add seconds we all have the same procedure just another change in the formula is to be made to make it work on seconds rather than hours or minutes.

We need to further multiply by 60, as we have 60 seconds in each minute. I hope you have understood the pattern, by default it captures a day if you add a number to a time (that’s why it remains unchanged), it shows you the same time after 3 days that’s why the time looks like it’s not changed.

Step 1

Further, multiply with 60. Step 2

Hit enter and you’re done. you can verify it manually to verify the result  Same as for subtraction, multiplication, and division.

I hope you have got an understanding of the patterns, how google sheets capture the time and how it evaluates the operations on days, hours, minutes, and seconds, there is no microsecond in google sheets as we have it in programming languages like JavaScript.

One more thing I would like to cover in the context of this article, you may have noticed that the time is rounding to the next day as it has more hours than 24.

We can control it by changing the formatting for time. Let’s show how it’s done

Step 1

Keep the cell selected, and go to Format Step 2

Number > Custom number format Step 3

A dialog box will appear, pick the [hh]:mm:ss format Step 4

Click on apply Now you can see the hours will exceed 24.  