grouping summary with a total

[tecas]

I have to generate an excel file showing machine capacity by week. our
work week is from monday ~friday. with a date field, how do i create
weekly totals? I want to show machine hours by machine, week.