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 Is it possible to then turn the Average handle time (seconds) to the correct time format.
@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")