call center duration

llyons - I have some articles on this that I think you will find helpful:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279#M92

https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

Hi, llyons 

Based on your desciprion, I created data to reproduce your scenario.The pbix file is attached in the end.

Table:

You may create a custom column as below in 'Query Editor'.

= Table.AddColumn(#"Changed Type", "Custom", each let dur=[End]-[Start]
in
#time(Duration.Hours(dur),Duration.Minutes(dur),Duration.Seconds(dur)))

In Power BI Desktop, you may create a calculated column as below to calculate total seconds.

TotalSeconds = HOUR([Custom])*3600+MINUTE([Custom])*60+SECOND([Custom])

Finally you may format the column as below.

Best Regards

Allan

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