How to Add Time in Google Sheets (Add Hours, Minutes, Seconds)

In this video, we will show you how to add time in Google Sheets.

In this sheet, we have a timestamp for clock in, and now we want to add the hours, minutes and seconds worked during the day to find out the clock out timestamp.

First, we would need to determine the correct format to enter the hours, minutes and seconds in the sheet.

To get started, let’s simply click on where we want the total to appear, and add the start time with the hours, minutes and seconds over here.

Now for example, if the resource has worked for 8 hours, we cannot simply enter 8 over here. You can see that the end result is incorrect.

To make sure the number represents hours, we need to divide it by twenty four. So let’s select the cell and enter the “equals to” sign. Then enter eight followed by the divide symbol and entering twenty four.

Once we hit enter, you can see that the clock out timestamp correctly determines the time.

Similarly there are sixty minutes in an hour, so while entering minutes make sure you divide the number by twenty four, for the number of hours in a day, and then sixty, to account for the number of minutes in an hour.

Now for seconds, we will need to divide the number by both the number of hours in a day along with the number of minutes in an hour and the number seconds in a minute. That’s why we have divided the number by twenty four and twice by sixty.

You can see the clock out time is updated accordingly.

Now let’s select the hours, minutes and seconds and open up the formatting tab. You can select the duration option here to show the correct formatting.

You can carry on by using the same formulas to add hours, minutes and seconds within your calculation.

That’s all!

❓💬 Would you like to know about any particular Google Sheets feature? Let us know in the comments below.

#HowTech #GoogleSheets
--------------------------------------------------------------------------------------------------------------

[yaminmohamed]

If I have written hours and minutes in two separate columns how can i add the time sheet total?

[jhmonlinestore]

Hi, I have a question, do we have any formula to change the date to next date on a particular time?

[generector]

Extremely valuable formula: =Value(Hour(now()+time(2, 0, 0)))+value(minute(now()))/60 now() time zone adjusted, minutes as %

[GearsBusinessSolutions]

not at all what i thought the subject line would teach. i need to know how to add a time in the cell where it's a popup to select if possible. thanks

[Dmal]

I have a question. Say I wanted to show how late or early an employee was how would I do that? For example if hey clocked in too early a 1:57 but was not due in until 2:00?

[jeanc.]

It sucks, man. It's just too much effort to such a simple calculation. Sheets must have a formula for that.