Create an Hours and Minutes dropdown menu for a single day period in Google Sheets

Learn how to create a time sequence for a whole 24 hour period with a single formula and use that in a Data Validation Dropdown Menu in Google Sheets.

See the full written tutorial here: https://yagisanatode.com/2021/12/22/calculate-the-total-duration-of-time-between-two-periods-in-google-sheets/

00:00 Intro & Example 01:04 Create a 24hr time sequence 08:42 Add time series to drop down 10:07 Up next

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/google-sheets

Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts. https://www.zazzle.com.au/collections/shortcuts_mousepads-119754792503977450

#GoogleSheets #Spreadsheets #GoogleEdu #administration #GoogleWorkspace ... https://www.youtube.com/watch?v=n20WKWzlLW0