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

%3CLINGO-SUB%20id%3D%22lingo-sub-694741%22%20slang%3D%22en-US%22%3EExcel%20list%3A%20Can%20you%20adapt%20established%20list%20for%20a%20different%20value%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-694741%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20to%20keep%20track%20of%20the%20student's%20attendance%20'times%22%20(in%20and%20out)%20for%20a%20state%20funded%20program.%26nbsp%3B%20I%20have%20created%20a%20list%20of%20time%20in%205%20minute%20increments%20(from%209%3A30%20a.m.%20through%209%3A00%20p.m.--different%20classes).%26nbsp%3B%20However%2C%20we%20have%20to%20also%20be%20exact%20if%20a%20student%20signed%20in%20at%209%3A37.%26nbsp%3B%20Is%20there%20a%20way%20to%20create%20a%20list%20to%20allow%20for%20manual%20input%20if%20the%20time%20is%20different%20than%20the%20list%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-694741%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-694814%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20list%3A%20Can%20you%20adapt%20established%20list%20for%20a%20different%20value%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-694814%22%20slang%3D%22en-US%22%3EIf%20I%20was%20to%20build%20this%20I%20would%20use%20a%20PowerApp%20to%20capture%20the%20student%2C%20class%20and%20time%20that%20adds%20an%20entry%20to%20Excel.%20This%20would%20enable%20you%20to%20not%20require%20presetting%20all%20the%20time%20blocks.%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted
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.