Weighted Calculation with Multiply Time

[Ramartin1]

Hello All,

I am new to Alteryx and I am trying to get the weighted Average handle Time in Alteryx by call handle.

In Excel my Formula is =(Average Handle Time/60*60)*Call Handle 

Example    (00:17:55 / 60 * 60) * 1 = 0.0124421 which is 00:17:55 

                  (00:14:20 / 60 * 60) * 1 = 0.0190074 which is 00:28:40

I want to take in account the amount calls handle in each row of my data. Not sure what route to take to then get the correct total new average handle time column. 

I attached sample of my data with the results WHAT in column 3 of my excel file. 

[NikyN]

Hello @Ramartin1,

Firstly I believe you will need to get number of seconds/or minutes out the time columns.

(DateTimeHour([Average Handle Time]) * 3600 + DateTimeMinutes([Average Handle Time]) * 60 + DateTimeSeconds([Average Handle Time]))

Then you can do any calculation you do in excel.

Best Luck!

Niky

[atcodedog05]

Hi @Ramartin1 

Can you share the excel with formula. The replication of your formula in Alteryx would be something like the below.

Hope this helps : )

[Ramartin1]

I didn't use a formula in Alteryx. I placed the results (numbers) of my excel in the weighted Average handle time in excel column within Alteryx to show my actual excel results. 

No sure why the seconds column is not matching the number in excel. What could be the case if I bring that number to excel it adds the am/pm.

[Ramartin1]

Sorry here is the example in the excel file.