Changing values on collapsed fields. Data Model/Pivot Tables

I'm using Data Model in Excel because I need weekly data for my locations. Other than scan times, I have no means of seeing the hours worked at a location.

To get the "Estimated Work Hours", I added a measure " =(([Latest Time]-[Earliest Time])*24)" This measure is working as intended.

When I collapse the data, it's still using the measure for my subtotal fields...so it's taking the earliest time and latest time for the week. What I need it to do is sum all the hours for the week. The sum for the week beginning 3/2/2025 should be 2.26 hours, not 5 hours.

Any recommendations on how to deactivate the measure for this subtotal? Or create a new measire to give the desired result?

Thank you!