Hi guys
I posted a few weeks back looking for some help with times etc in Excel and got my answer. Now I have all the data i require (for a bus punctuality log) im looking to compile all the results into 1 page but just not sure how exactly I would go about doing it. I've attached it to this thread and just looking for some help and advice as these results will be published to the media on 11th March.
As you can see from the "halfway results" all the data entered is hand entered and I was looking to do the final results in a similiar way, with having each bus number and having the amount of submissions made on that bus, how many times it was late and early, amount of total mins it was late, amount of total mins it was early and a average on how late it was etc. I also want to be able to add the total lateness of all the buses submitted on the spreadsheet (I can do that already).
I was just looking for advice on the best way to do this, Thanks in advance.
Bookmarks