rhopman
asked on
Business days caclation in Crystal Reports
I have two fields; date1 and date2. The fields are both formatted as yyyymmdd. What is the formula to take Date1-Date2 to calculate turnaround time for business days only?
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
However I needed to know business time (working time) so that the datediff ignored weekends, bank holidays, knows the opening and closing time of the business so that to see in hours the difference beteween two dates it only counts betweeen 0900 and 1700 on weekdays.
If you need something like this then let me know and I can send you the functions.
Cheers