Time Measure sum Time Measure error

HI Anonymous ,

You can try to use the following measure formula:

Total time =
VAR tsCS =
    SUMX (
        'Calls SQL',
        VAR _t1 =
            TIMEVALUE ( 'Calls SQL'[Total Time on Calls] )
        VAR _t2 =
            TIMEVALUE ( 'Calls SQL'[Wrap Time] )
        RETURN
            ( HOUR ( _t1 ) + HOUR ( _t2 ) ) * 3600
                + ( MINUTE ( _t1 ) + MINUTE ( _t2 ) ) * 60
                + SECOND ( _t1 )
                + SECOND ( _t2 )
    )
VAR tsBK =
    SUMX (
        'Breaks',
        VAR _t1 =
            TIMEVALUE ( 'Breaks'[Minutes] )
        RETURN
            HOUR ( _t1 ) * 3600
                + MINUTE ( _t1 ) * 60
                + SECOND ( _t1 )
    )
VAR ts = tsCS + tsBK
VAR _hour =
    INT ( ts / 3600 )
VAR _minute =
    INT ( MOD ( ts, 3600 ) / 60 )
VAR _second = ts - _hour * 3600 - _minute * 60
RETURN
    _hour & ":"
        & FORMAT ( _minute, "00" ) & ":"
        & FORMAT ( _second, "00" )

Regards,

Xiaoxin Sheng