Thank you for your kind welcome. My responses to your questions are below. Thanks for your help!
1) Most events run about 8 hours, but as little as 1.5 hours and as much as 18 hours.
2) If it begins at 11:59PM and Duration is 3 minutes I just want there to be a tick in the 11:00pm and 12:00am fields for the day(s) in which a Yes exists, since it falls between those times
3) If it begins on Sunday at 11:59PM and Duration is 3 minutes, do you then have two "Yes" entries in the days of the week: one for Sunday and one for Monday, and if not, which one do you have? I would have 1 tick for the Sunday 11:00pm and 1 for Monday 12:00am since it falls between those two hours
4) If it begins on Sunday at 11:59PM and Duration is 3 hours, how many "Yes" entries do you have in the days of the week? The yes entries correspond to the start times, meaning that the sunday column would have a Yes and unless it begins again on Monday at that time, it would be a No
5) If it begins on Sunday at 11:59PM and Duration is 3 hours, how many "X" ticks do you want to have? 1 tick in each of the fields for Sunday 11:00pm, Monday 12:00am, Monday 1:00am, Monday 2:00am
Basically the end result I want is "Is this backup running on this day at this time? If so, put an X in the cell where that backup's row meets that time's column
It may also help, here are the first 2 rows of my sheet with the header names:
| | | | | | | | | | | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
NAME of backup | Start Time | Duration | End Time | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | 12:00 AM | 1:00 AM | 2:00 AM | 3:00 AM | 4:00 AM | 5:00 AM | 6:00 AM | 7:00 AM | 8:00 AM | 9:00 AM | 10:00 AM | 11:00 AM | 12:00 PM | 1:00 PM | 2:00 PM | 3:00 PM | 4:00 PM | 5:00 PM | 6:00 PM | 7:00 PM | 8:00 PM | 9:00 PM | 10:00 PM | 11:00 PM | 12:00 AM | 1:00 AM | 2:00 AM | 3:00 AM | 4:00 AM | 5:00 AM | 6:00 AM | 7:00 AM | 8:00 AM | 9:00 AM | 10:00 AM | 11:00 AM | 12:00 PM | 1:00 PM | 2:00 PM | 3:00 PM | 4:00 PM | 5:00 PM | 6:00 PM | 7:00 PM | 8:00 PM | 9:00 PM | 10:00 PM | 11:00 PM | 12:00 AM | 1:00 AM | 2:00 AM | 3:00 AM | 4:00 AM | 5:00 AM | 6:00 AM | 7:00 AM | 8:00 AM | 9:00 AM | 10:00 AM | 11:00 AM | 12:00 PM | 1:00 PM | 2:00 PM | 3:00 PM | 4:00 PM | 5:00 PM | 6:00 PM | 7:00 PM | 8:00 PM | 9:00 PM | 10:00 PM | 11:00 PM | 12:00 AM | 1:00 AM | 2:00 AM | 3:00 AM | 4:00 AM | 5:00 AM | 6:00 AM | 7:00 AM | 8:00 AM | 9:00 AM | 10:00 AM | 11:00 AM | 12:00 PM | 1:00 PM | 2:00 PM | 3:00 PM | 4:00 PM | 5:00 PM | 6:00 PM | 7:00 PM | 8:00 PM | 9:00 PM | 10:00 PM | 11:00 PM | 12:00 AM | 1:00 AM | 2:00 AM | 3:00 AM | 4:00 AM | 5:00 AM | 6:00 AM | 7:00 AM | 8:00 AM | 9:00 AM | 10:00 AM | 11:00 AM | 12:00 PM | 1:00 PM | 2:00 PM | 3:00 PM | 4:00 PM | 5:00 PM | 6:00 PM | 7:00 PM | 8:00 PM | 9:00 PM | 10:00 PM | 11:00 PM | 12:00 AM | 1:00 AM | 2:00 AM | 3:00 AM | 4:00 AM | 5:00 AM | 6:00 AM | 7:00 AM | 8:00 AM | 9:00 AM | 10:00 AM | 11:00 AM | 12:00 PM | 1:00 PM | 2:00 PM | 3:00 PM | 4:00 PM | 5:00 PM | 6:00 PM | 7:00 PM | 8:00 PM | 9:00 PM | 10:00 PM | 11:00 PM | 12:00 AM | 1:00 AM | 2:00 AM | 3:00 AM | 4:00 AM | 5:00 AM | 6:00 AM | 7:00 AM | 8:00 AM | 9:00 AM | 10:00 AM | 11:00 AM | 12:00 PM | 1:00 PM | 2:00 PM | 3:00 PM | 4:00 PM | 5:00 PM | 6:00 PM | 7:00 PM | 8:00 PM | 9:00 PM | 10:00 PM | 11:00 PM |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="9"><col span="3"><col span="9"><col span="3"><col span="9"><col span="3"><col span="9"><col span="3"><col span="9"><col span="3"><col span="9"><col span="3"><col span="9"><col span="3"><col span="9"><col span="3"><col span="9"><col span="3"><col span="9"><col span="3"><col span="9"><col span="3"><col span="9"><col span="3"><col span="9"><col span="3"><col span="9"><col span="2"></colgroup><tbody>
</tbody>