duration field when calculating the average is showing more than 24 hours about metabase HOT 5 OPEN

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

from metabase.

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

from metabase.

any updates anyone ?

from metabase.

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

from metabase.

@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)

from metabase.