Student Class Schedule

I’m building an app based on a student’s class schedule. I would like to add a format rule indicating the class period the student is in. Something like if Now() is between these two times, it is 1st period. If Now() is between a different set of times, then it is period 2, and so on…

I am REALLY confused by the time functions!

Thanks!

1 Like

Have a look at this and scroll down to the list of ways to calculate time.

https://support.google.com/appsheet/answer/10107326?hl=en

1 Like