Excel Formula for Time Sheet and Ticket Reporting

Job ID: 33100292

Budget: $10 – $30 USD

I need a hand in 2 things.
1. Time Sheet Reporting
2. Ticket Reporting

NOTE: Both above needed xlsx file will come from 1 report