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 V...