Excel list: Can you adapt established list for a different value?

Copper Contributor

We have to keep track of the student's attendance 'times" (in and out) for a state funded program.  I have created a list of time in 5 minute increments (from 9:30 a.m. through 9:00 p.m.--different classes).  However, we have to also be exact if a student signed in at 9:37.  Is there a way to create a list to allow for manual input if the time is different than the list?

1 Reply
If I was to build this I would use a PowerApp to capture the student, class and time that adds an entry to Excel. This would enable you to not require presetting all the time blocks.