Dividing Timespan value with a real/integer value

[Naoki Yamaguchi]

Hi I'm looking at call center data and have daily rows that has the aggregate talk time for a call center representative along with the total calls they took.

My data looks something like below:

 

Date Rep Calls Taken Total Talk Time Team

1/1/16 John 56 5:17:55:0000 A

1/1/16 Amy 504:20:47:0000 A

 

I'd like to calculate a value in a graphical table by Team that will display the Average Talk Time Per Call

Team Avg Talk Time per Call

A xxxxxxx

I'm trying Sum([Total Talk Time]) / Sum([Calls Taken]), but it's telling me it's an invalid type for function call '/'. What is the best way to do this calculation

[Johanes Askabe]

You are trying to divide a time formatted data with an integer (# of calls). Try converting the time data to decimals and then divide.

[Shaun Simon]

Careful on the decimal conversion... since time isn't base 100 this will throw off your stats. It's best to convert the HH::MM::SS to just Seconds which will be of type INT then roll it up by hour/Min/what ever you want.

[Johanes Askabe]

It shouldn't make a difference unless when converting from decimal time to formatted time, then the appropriate multipliers should be used to convert to minutes or hours.

For example 5:17:55 = 5+17/60+55/3600 in HRS

[Bar Tek]

Agree that best approach is to use seconds in TimeSpan and then utlize function TotalSeconds to get integer value and be able to divide by 60 to getminutesof whatever you need.