Weighted average based of incoming volume and AHT per case in seconds

I want o calculate the weighted average for the AHT column in the below data

Date Volume AHT per case in sec 1/2/2019 7188 44 sec 2/2/2019 453 123 sec 3/2/2019 345 563 sec

Like this i have data for 30 days. I want to calculate the weighted average AHT for the 30 day period. Direct average doesn't work here since the AHT column is driven by volume. Can you please help me with this

• Question is unclear, also can you format you data better. – user2974951 Sep 18 at 12:42