Hi Mynda, I attached a file that contains more frequency of ticket time (loading times) to demonstrate the data I'm trying to capture. Hopefully...
Hi Mynda, Sorry for all the confusion. Basically I am trying to calculate the average minutes within an hour of a day to process (load trucks) t...
Hi Mynda, Sorry, please see attached file. Thanks John
Hi, I tried the Power Query and it helped me to obtain the data and organized it. The problem I still have is calculating the average minutes for ...
Thank you Anders, This is very helpful
I guess I shouldn't have used the word upload. I want to add future date data to the existing Excel file and I'm concerned it will become too large o...
Hi Mynda, Thanks for your reply. The problem I'm having is how to upload additional dates to capture the Average per hour. I update a file wit...
Sorry, I selected the wrong file. I have now attached the correct file.
Hi Mynda, I'm still struggling with this report. I decided to start to by extracting one days worth of data and use a Pivot Table to evaluate the ...