Challenge Accepted

A few weeks ago, maybe a few months now, I created a schedule using ClaudeAI to make a testing clock. 

It's functional. It works. 

Today I noticed that my colleague, who also does testing accommodations, had a spreadsheet projected on the whiteboard with the times.

When he projects it on the whiteboard, it looks like this:

I asked about the formulas in it. At the time, he didn't have any. 

My mind immediately went to work about how to make it work in Google Sheets. 

I had the basic structure in my mind. During my break I went to work building it. 

When we give accommodations, we write the start time, 30 minutes remaining, 5 minutes remaining, and the end time. Calculating this is always a chore. 

To the spreadsheet! 

I knew I wanted a drop-down of student names. This would eventually be for all students in inclusion support, so it would be quick and easy to use.

I found online that I could use a formula called =TIME. Using ChatGPT, I was able to do a VLOOKUP with all the names that looks like this - =B4+TIME(0,B3,0)+TIME(0,B8,0)

Here are all my formulas for this one.

=B7-TIME(0,5,0)

=B7-TIME(0,30,0)

=B4+TIME(0,B3,0)+TIME(0,B8,0)

=B3 + (B3 * IFERROR(VLOOKUP(B1, E4:F7, 2, FALSE), 0))

My tool

Here's a link to the working example.

https://docs.google.com/spreadsheets/d/15FjeNAyHnTran4ejfxk4M477AJrGNJFjxo6P_m2VpZI/edit?gid=1058096702#gid=1058096702

I'll start making it look better tomorrow. I also have to check my formulas.