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

[@AnthonyEnglish]

I love the succinct, step-by-step method of how you explain this. And I had never thought of doing a time as a dropdown. Brilliant! Thanks (Anthony from Sydney).

[@yagisanatode]

Thanks, Anthony. Glad you found it helpful.

[@adnanjavedg]

Thanks for the video. for 1 minute intervals =ARRAYFORMULA(SEQUENCE(60*24,1,0,1)*1/(60*24)) for 15 minute intervals =ARRAYFORMULA(SEQUENCE(60*24,1,0,15)*1/(60*24))

[@WarganetLifeOfficial]

Thanks 😊

[@guyinsandiego7257]

Great information presented in a clear concise manner. One update though, in the Excel version included in Office 365 the "Arrayformula", that is first referenced at the 6 minute mark, is assumed and so you can omit this from the formula which leaves you with =(SEQUENCE(60*24,1,0,1) *1/(60*24)). Thank you for the great tutorial!

[@yagisanatode]

Thanks for the kind words. This is a Google Sheets tutorial, but good to know about MS Office 365.

[@premsingh_112_yt]

Really it was very nice.....Thanks for a video

[@jc2094]

I am not getting the option for "List from a range" when I select Data Validation. Is there a change due to updates since you originally posted this video?

[@yagisanatode]

Yes, it's still there. In the data validation sidebar select 'Criteria' > 'Dropdown (From a range)'

[@rici_22]

Legend fella! 🤜🤛

[@parsseo]

Hi is there a way that i choose the Date in first column and data of whole sheet change. Like every tasks Of Days For employees?

[@yagisanatode]

Hi Mohammad, the only thing that comes to mind here is to use Apps Script with the onEdit() custom simple trigger. developers.google.com/apps-script/guides/triggers

[@vaishakhviswambharan8793]

How to add second

[@TheVanZane]

Amazing, thank you!

[@yagisanatode]

Glad you liked it!

[@darrenbakai9646]

Very easy to follow. Thank you.

[@yagisanatode]

You are welcome!

[@Shanmugam-g4l]

how to calculate a duration time bro

[@yagisanatode]

Have a look at his tutorial: yagisanatode.com/calculate-the-total-duration-of-time-between-two-periods-in-google-sheets/

[@kukukwahyu1204]

SOO COOL, THANKS

[@yagisanatode]

No problem!