Turnaround Time Average Formula

tim.curtin

Hello All!

Need some help have no clue where to start.

I have been tasked to create some metrics around turn around times. What i would like to show are things like

Average Turnaround Time. Values would be date submitted to date completed.

I thought something like =AVG(WORKDAY({Date Submitted, {Date Completed})) would work but that would be too simple haha.

Any help would be appreciated! Thank you!

Itai Perez

Hey @tim.curtin ,

Can you share some screenshots please?

tim.curtin

This is the source date, in date formatting in SS. I put it in a report for viewing purposes, I'm sourcing my formulas from the sheet.

My metric sheet is setup as so to return average values and counts.

Carson Penticuff

Are you able to add another column to the source sheet to calculate days to complete for each row? I think this will be necessary.

Your formula for the new column would be:

=IF(ISDATE([Date Completed]@row), NETWORKDAYS([Date Submitted]@row, [Date Completed]@row), "")

Then you can use this formula in your metrics sheet:

=AVG({Days to Complete})

Paul Newcome

You will need a helper column on the source sheet that calculates the number of days on each row.

=IFERROR(NETWORKDAYS([Date Submitted]@row, [Date Completed]@row), "")

Then in the metrics sheet you can use a basic AVG function.

=AVG({Source Sheet Helper Column})