How To Calculate Time In Google Sheets

How To Calculate Time In Google Sheets

Whether you want to prepare a financial spreadsheet or record large volumes of data, Google Sheets has got you covered. It is one of the best spreadsheet programs that are capable of doing neat things. Also, it is the perfect alternative to Microsoft Excel.

The best aspect of Google Sheets is how flexible it is. It can be used as a text editor, statistical modeling, database, media library, calculation engine, to-do list, and more.

It can also be used for tracking billable hours or employee time schedules. If you are using Sheets for this purpose, you will have to calculate the time difference between two different events. Even though Google Sheets is not designed for timing log functions, it can still be persuaded with a little preparation.

In this post, we will tell you how to calculate time in Google Sheets. This will help you to calculate the difference between two timestamps.

Steps to calculate Time in Google Sheets:

  1. Open Google Sheets:
Open Google Sheets
  1. Now, select the column where the time would be entered:
select the column to enter the time
  1. Now, select the Formats and click Time:
Select Times format
  1. Now, on the third column where the time will be calculated, change the format to Duration:
add third column
change format to duration
  1. Now, enter the time on the time columns:
Enter time in the columns
  1. Now, on the Hours Worked enter the formula :


Calculate time in Google Sheets
  1. Now, extend the formula and apply it to all the subsequent cell:
Find the time worked

Learn how to add a second timezone to Google Calendar.