I need to add 3 column of time and then the divide by a column number number

[Rmartin8]

Hi,

I want to add to 3 columns that contain time and then divide them by a column name call handle. 

Formula trying to do in Alteryx 

Average Handle Time = Wait Time + Hold Time + Talk Time / Calls Handle

Calls Handle	Wait Time	Hold Time	Talk Time	Average Handle Time
8	00:24:07	00:03:59	00:04:00	Wait Time + Hold Time + Talk Time / Calls Handle
26	01:34:17	00:16:30	00:10:13

Thank you in advance!

[atcodedog05]

Hi @Rmartin8 

Here is how you can do it.

Workflow:

Hope this helps : )

[Rmartin8]

@atcodedog05  Is it possible to then turn the Average handle time (seconds) to the correct time format.

[binuacs]

@Rmartin8 to convert it into HH:MM:SS format you can do something like below

PadLeft(ToString(Mod([Average Handle Time]/3600,3600)),2,"0")+":"+

PadLeft(ToString(Mod([Average Handle Time]/60,60)),2,"0")+":"+

PadLeft(ToString(Mod([Average Handle Time],60)),2,"0")

[atcodedog05]

Hi @Rmartin8 

Here is how you can do it.

Workflow:

Hope this helps : )