Jump to content

Dividing Timespan value with a real/integer value

Naoki Yamaguchi

Recommended Posts

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

Link to comment
Share on other sites

  • 4 years later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...