How to input time in 15 minute increments

[RickyK]

I will appreciate if you could help me.

[1minManager]

this should help. you might need to convert your time into a duration though

help.appsheet.com

MINUTE()

Minute of hour from Duration

[Marc_Dillon]

Also this:

FAQ: Rounding DateTime, Duration, and Time values Tips & Tricks 💡

Round DateTime value to nearest 5 minutes Round Duration value to nearest 5 minutes Round Time value to nearest 5 minutes

[RickyK]

Thanks, Marc_Dilon.
I would like to round time in little bit complex way. For example, change from 7:05 to 7:00, from 7:10 to 7:00, , from 7:14 to 7:00. But if it over 15, then change from 7:16 to 7:15. Same way at 30, 45, 60.

[Steve]

Read the article @Marc_Dillon posted.