A quick way to validate times with Data Validation in Google Sheets
Links to more information below!
See the full written tutorial here: https://yagisanatode.com/2021/12/22/c...
Learn a quick hack to validate times in Google Sheets.
This video is part of a series in duration and time calculation so don't forget to subscript to get the next video.
Like and subscribe to find out when the next tutorial on how to import specific data with QUERY, FILTER and VLOOKUP.
Contents
00:00 Intro & Example
00:31 Example
00:46 The approach
02:03 Possible flaw
02:39 Solution
If you like the video, check out my website:
https://yagisanatode.com/
Here is the link to just Google Sheets tutorials:
https://yagisanatode.com/google-sheets/
Get your copy of the Google Sheet Project Task Manager here: yagisanatode.teachable.com/p/google-sheets-project-tasks-manager
Sign up for my course:
Google Sheets: Learn the Essentials with Three Detailed Projects
https://yagisanatode.teachable.com/p/...
Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts.
https://www.zazzle.com.au/collections...
#GoogleSheets #Spreadsheets #GoogleEdu #administration #GoogleWorkspace
Watch video A quick way to validate times with Data Validation in Google Sheets online, duration hours minute second in high quality that is uploaded to the channel Yagisanatode -Scott- 22 December 2021. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 7,512 times and liked it 23 visitors.
