duration field when calculating the average is showing more than 24 hours

[hamdyyy9]

Describe the bug

we have a column that has hours , minutes and seconds , when you make an average it showed us the hours as 31 hours , will it should round it after 24 for sure.

To Reproduce

• have some data in duration field with periods in multiple days
• perform average on this data
• check the outputted results

Expected behavior

correct
O years 0 mons 34 days 7 hours 46 mins 15.065174 secs
wrong
O years 0 mons 33 days 31 hours 46 mins 15.065174 secs

Information about your Metabase installation

- Google Chrome Version 122.0.6261.112
- Metabase version 0.48.8

Severity

messing up some calculations checks

Additional context

[paoliniluis]

so you say that we're calculating the average wrong?

[nofalx]

We are facing the same issue, it is not that the calculation is wrong but that the format seems to be not correct.

In this case shouldnt the 31 hours be interrupted as + 1 day and 7 hours? As in hours shouldnt go above 24 hours

[hamdyyy9]

any updates anyone ?

[paoliniluis]

Ok so what you need is that we format the time correctly, is that the issue then?

[nofalx]

@paoliniluis

Thank you ,Yes:

• We would need to not have the hours exceed 24 hours, but instead add +1 day and show the remaining hours
• Optionally if possible, it would be nice if we can have multiple formats for duration field (total seconds or duration string)