Automate Report

Hi Guys,
I am new to VBA and I am having trouble figuring out the logic behind this. I have attached the excel sheet for reference(Thought it would be pretty hard to explain). It consists of the Input sheet(how I get the raw data) and output sheet(how I should present it using vba). I want it to be dynamic so that in future if I copy paste new set of data in input sheet, it should generate the required output. Your help in this regard would be greatly appreciated. Thank you in advance.

Regards
Vradhak7

hi vradhak7, option, please check attachment, press Run button or run code "test"(ALT+F8, select "test", press Run button)

If to follow Output sheet logic, number of days is multiplied by 8 hours and AM/PM should be used based on column 3 of Input sheet. If I'm wrong on this assumption I would correct it the way it is in Output sheet.

That worked just the way I wanted. Thanks a lot watersev! Greatly appreciated,....