How to input time in 15 minute increments

AppSheet AppSheet Q&A
1

I will appreciate if you could help me.

2

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

2 Likes
3

Also this:

[FAQ: Rounding DateTime, Duration, and Time values](https://community.appsheet.com/t/faq-rounding-datetime-duration-and-time-values/31686) Tips & Tricks ?

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

4 Likes
4

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.

1 Like
5

Read the article @Marc_Dillon posted.

1 Like