Rearranging Production Data According to Dates

Hello all,

I currently have got a production schedule that is sorted by the products a machine is manufacturing, and would like to rearrange it according to the amount of products produced for each day instead. How can we sort such a data out, and is a macro required? I've tried calculating the production rates per hour based on the duration, but the way Excel sorts out cells related to time and duration is so user-unfriendly. Can someone help me out with this? I've attached the file to this for your perusal.

Thanks so much in advance! I really appreciate it!