How to use Google Sheets. Add or subtract minutes in Google Sheets Theres the TIME function that adds and subtracts up to 60 minutes. In this article well show you how to stop Google Sheets rounding numbers to get the exact value entered.
These are great time worksheets to test your students understanding of adding or subtracting time.
Repeat for the second Time Out time column. Click Tools Script editor. The examples here are the same as in the first image except I am now using a search_key of -1 instead of 1 to reflect the fact that the data is sorted in descending. Quite simply you enter numbers representing a year a month and a day eg.