Calculate fractional days 1

[kathleenhle]

Hi, I'm writing a report to calculate the turnaround time for my lab. I found the formula to compute "working days" of Mr. Ken Hamady just exactly what I need. Thanks very much to that. Now I want to count the time also (a working day with 8 hours), which expects to return a fractional time, e.g. days in lab = 34.25 days.
Any ideas, and help are greatly appreciated.

 

[kenhamady]

Look at formula #13. It does business hours. You should then be able to convert the hours to days with a fraction by dividing by 8. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.