Google Sheets FILTER function and Times
This tutorial will explore using the FILTER function with time values in Google Sheets. To play along grab a copy of the starter sheet here:
https://yagisanatode.com/google-sheet...
We will start off by using a cell reference to filter a time in our Google Sheets. There are some tricky gotchas to filtering in-line and we will cover them next by using either the TIME function or the TIMEVALUE function. Next, we will run through some quick examples to FILTER times after or before a time or between two times.
To the written tutorial: https://yagisanatode.com/google-sheet...
00:00 Intro setup
00:29 Range equals time cell
01:50 Range equals TIME function
06:40 Range equals TIMEVALUE function
07:49 Range greater or less than cell reference
08:26 Range greater or less than TIMEVALUE
10:25 Range between two TIMEVALUE functions
** My Site **
https://yagisanatode.com/
** More on Google Sheets **
https://yagisanatode.com/google-sheets/
** The Named Functions Pack **
https://yagisanatode.com/products/nam...
Courses *
https://yagisanatode.com/products-cat...
Google Workspace Tools *
https://yagisanatode.com/products-cat...
Google Workspace Add-ons *
https://yagisanatode.com/products-cat...
#GoogleSheets #googleworkspace #spreadsheets #businessadministration #admin #businessmanagement
