Skip to Content
Former Member
Feb 07, 2008 at 06:23 AM

Average of Turnaround Times


Post Author: cawade

CA Forum: Formula

I have a report for which I need to monitor the time taken for the work to be completed for each customer (excluding weekends) ie the turnaround time.

I am using the following:

Local DateTimeVar d1 := {First Date};

Local DateTimeVar d2 := {Last Date}

DateDiff ("d", d1, d2) -

DateDiff ("ww", d1, d2, crSaturday) -

DateDiff ("ww", d1, d2, crSunday)

This work well.

My question is how do I get the average turnaround time.

Thanks in advance.