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
Смотрите видео A quick way to validate times with Data Validation in Google Sheets онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал Yagisanatode -Scott- 22 Декабрь 2021. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 7,512 раз и оно понравилось 23 посетителям.
