Create a custom time sequence with a single formula in Google Sheets
Scott Yagisanatode
Grab the formula and written tutorial here: https://wp.me/p9ksIb-6X5
Learn how to easily create a custom time sequence in Google Sheets with editable start and time as well as editable steps in the sequence, all with a single formula.
Contents 00:00 Intro 01:27 Build input fields 03:46 Get number of rows 08:17 Get start as minutes 08:55 Get steps as minutes 09:33 Create sequence in min 10:31 Convert sequence to time value 12:39 Combine everything into 1 formula 16:28 Testing the formula
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=C3u-eC6R2r4
43481998 Bytes