How do I calculate turnaround time?

[AnthonyM]

I am currently using FMP 3.0v4. I am trying to set up a report that will give me turnaround time of working days (mon-fri) on how long it takes to complete jobs. I've set up two fields and date in and a date out. Using these 2 fields I'd like to calculate the number of days. For example if a job comes in Thursday and out on Monday I'd like the result to be 3 days. Please let me know if there is a way of doing this.

Thank you in advance

[Chuck]

Try the file downloadable from this link:

http://www.databasepros.com/FMPro?-db=resources.fp3&-lay=cgi&-format=list.html&-error=error.html&released=1&-sortfield=new&-sortfield=rating&-sortfield=creation_date&-sortorder=des cend&-max=5&-find=+&search=work+days

It should help.

Chuck

[Vaughan]

Errr, why not just subtract the two dates?

BTW update to FMP 3.0v6 anything older is not Y2K compliant.