[Excel x AI] Turn a calendar into a shift schedule! How to create a table where you can enter staff names, working hours, and days off

Hi everyone, it's Airu. “The dates and days of the week are automatic now, but I can't use this as a shift schedule as it is.

How to calculate late-night and overtime hours in Excel attendance sheets: Pitfalls of overnight shifts, 15-minute rounding, and exceeding 24 hours

Suppose that at the end of the month, you enter your start time, end time, and break time into an Excel attendance sheet ...