For example, if the duration format is to display as hours, the content cells will show durations greater than 24 hours as hours, but the summary sum will not. Here’s a demonstration:
Yes please fix this. When I need to summarize hours for a week in a timesheet, or in a month for an invoice, I’d rather not have to do mental math because it won’t respect the format of the column.
Edit: This also affects Charts that you might want to do. If you were charting your durations it would change the axis into numbers relative to days rather than the format chosen, hours in this case. So you start to see something like this…