How to Calculate Time in Google Sheets (Hours, Minutes, Seconds) | Calculate Time Difference

Опубликовано: 05 Декабрь 2021
на канале: Excel, Word and PowerPoint Tutorials from Howtech

129,302

695

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

You can calculate the duration between two timestamps. This can be done through formatting the data and using simple calculation to find out the time. For example, we have a sheet over here with the names of employees along with when they clocked in and clocked out of work. Over here, we will be first formatting the data properly before doing any calculation.

First of all, let’s start by selecting the columns containing both Time in and Time Out data. Next, let’s open up the more formats option here, and select the “Time Option”.

You can see that the data is now properly formatted.

Similarly, let’s select the Hours Worked column here, move to the formats section and select the Duration option. This is because in this column, we will be calculating the number of hours the employee has worked during the day.

Next, let’s select this cell and enter the equals to sign. Now we will select the Time out Cell reference and minus it from the time in cell reference.

Once you hit enter, you can see the number of hours worked during the day. We can simply copy and paste the formula for the remaining cells.

That’s all!

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

#HowTech #GoogleSheets
--------------------------------------------------------------------------------------------------------------
✅ All our announcements are available here https://t.me/howtechtv
✅ Commercial questions [email protected]
✅ Facebook   / howtechtv
✅ Instagram   / howtechprojects
✅ Twitter   / howtechprojects