Duration Conversion and Calculation

Hi Tevon713 ,

Here are the steps you can follow：

1. Create calculated column.

Convert Time to Second：

seconds =
var _day=VALUE(left('Table'[Incident Duratio:create-resolve],2))
var _hour=VALUE(MID('Table'[Incident Duratio:create-resolve],4,2))
var _minute=VALUE(MID('Table'[Incident Duratio:create-resolve],7,2))
var _second=VALUE(RIGHT('Table'[Incident Duratio:create-resolve],2))
return
_day * 24 * 60* 60
+
_hour * 60 * 60
+
_minute * 60
+
_second

average time：

Duration Average =
RIGHT ( "0" & INT ( AVERAGEA ( 'Table'[seconds] ) / ( 24 * 60 * 60 ) ), 2 ) & ":"
    & RIGHT (
        "0"
            & INT (
                (
                    AVERAGEA ( 'Table'[seconds] )
                        - INT ( AVERAGEA ( 'Table'[seconds] ) / ( 24 * 60 * 60 ) ) * ( 24 * 60 * 60 )
                ) / 3600
            ),
        2
    ) & ":"
    & RIGHT (
        "0"
            & INT (
                (
                    AVERAGEA ( 'Table'[seconds] )
                        - INT ( AVERAGEA ( 'Table'[seconds] ) / 3600 ) * 3600
                ) / 60
            ),
        2
    ) & ":"
    & RIGHT (
        "0"
            & (
                AVERAGEA ( 'Table'[seconds] )
                    - INT ( AVERAGEA ( 'Table'[seconds] ) / 60 ) * 60
            ),
        2
    )

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly