Forum Discussion
How to make a Team Schedule tracker
To explain my problem, let me give you all a basic structure on how I receive the data. Please note: I really don't want a complete solution but a direction I can go. All of this is too much of ...
Hey, I saw a pivot table you made with respect to the timings. It was very close to what I want. All I want to change is to add the whole timeline from the start of the day to the EOD in terms of Yes/No or 0/1 as in available or not available respectively.
Link is given below:- https://docs.google.com/spreadsheets/d/18W7ou_FBQ8wHTXyiCQjaBkWE6WJkamsQxQlIFrRz3WE/edit#gid=464510138
Link is given below:- https://docs.google.com/spreadsheets/d/18W7ou_FBQ8wHTXyiCQjaBkWE6WJkamsQxQlIFrRz3WE/edit#gid=464510138
parthsahay I'm rather pragmatic and don't want to overcomplicate matters. Since the pivot table option seems to work just fine, I added a few dummy rows to the bottom of the table with tutor " " who has classes every hour from 10AM to 10PM without students. That gives you the time span you want in the pivot table. Would that work for you?
- In a few place it seems tutor is having 2 session at some places. Might be because of multiple entries on the same timeline. Rather than that everything is how I wanted. I'll just put conditional formatting to put Yes or No in the same place if required. Thanks a lot Riny_van_Eekelen