The format of a duration column is not applied to the column summary

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:

1 Like

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…

Hi @Thomas_Robbs1 ,

I also have this issue… The workaround is the following


where Duration is the column with the Duration format