Hi Ayushi,
This template makes two assumptions that, in your case, are not true:
The Daily Schedule template assumes that all of your scheduled appointments have the same duration (either 30m or 1h), and that there is no time between the end of one event and the beginning of the next.
The single column containing start times assumes that each day of the week will have events starting at the times listed in the single column of start times.
You have stated that your schedule is "not that consistent" and provided an example of two events, one scheduled for one hour, the other for half an hour.
To accommodate that variance in appointment lengths, you'll need to set the Time Blocks table to the length of your shortest appointment booking time, then extend the schedule table to as many rows as needed to get to the end of the day,
In the example below, the Time Blocks have been set to 15 minutes.
That means a fifteen minute appointment will need a name in one row of that day's column, a half hour appointment will fill two blocks, and a one hour appointment will fill four blocks.
Here's an example with six appointments recorded on two days. I didn't extend the table to a full day as it needed to fit in a screen shot. Select any cell to show the row and column reference tabs and the Row control at the bottom left. Drag this control downwards to add more rows
Monday has two appointments—Jones for one hour, starting at 8:00 AM, and Smith for 30 minutes, starting at 9:00 AM.
Tuesday has four appointments, Brown for 15 minutes, Black for a half hour, Sanchez for 45 minutes and Levine for one hour.
Each of the appointments was entered manually, with the 'full name' entered on the row for the starting time, and an initial entered in each of the fifteen minute blocks needed to complete the duration of the appointment. (If Text alignment in these columns were set to 'centred', quotation marks or an asterisk could be used as the 'filler' markers in place of the initial. L Aligned left, these smaller markers would be less visible than letters.
This modification of the table requires NO changes to the existing formulas in column A (calculating the start times of each time block, using the information in the Start Time and Time Blocks tables above the main table.
The only changes to the table produced y the template are to:
Change the values in Start Time and Time Block tables to fit your needs.
If necessary, reduce the row heights to reduce the height of the table.
If you are not using the tables on the extra sheets, delete those sheets.
Regards,
Barry
