Have set up a spreadsheet where I need to set up percentages but to me, it is not straightforward as I'm a beginner. This spreadsheet concerns parental visits and is to show the percentage of whether the driver was late, who was the driver, if alternate drivers were used, if drop off was on time, if drop off was late, etc etc. The first column is the date. Each of the other columns for that date will have something entered to show if late, on time, who was driving, etc. The period will go back 18 months. I need to show the percentage of how many times they were late, how many times the driver was the mother, how many times alternate drivers were used, etc over the total 18 month period.
So in the date column I will enter the date. And in the appropriate columns I am guessing I would enter number 1, as in whether an alternative driver was used, whether late, whether on time. Am guessing that column would need to add a total.
But since it is set up in this way, I am not sure how to set up percentages to show what I need to, which is percentages over 18 month period of the dates entered the lateness, driver used, etc. It's to present to a court. Then I also need to set up pie charts based on the percentages.
Any help would be much appreciated
So in the date column I will enter the date. And in the appropriate columns I am guessing I would enter number 1, as in whether an alternative driver was used, whether late, whether on time. Am guessing that column would need to add a total.
But since it is set up in this way, I am not sure how to set up percentages to show what I need to, which is percentages over 18 month period of the dates entered the lateness, driver used, etc. It's to present to a court. Then I also need to set up pie charts based on the percentages.
Any help would be much appreciated
