Business Days (5.5 Days??)

[Monkeyboy126]

Hi

I've seen many formulas to utilise business days but my requirement is slightly different. I run a helpdesk which has operating hours of 8.00 - 18-00 Mon - Fri & 8.00 - 13.00 Saturday.

In calculating the amount of business days a call has been open, how do I incorporate the 5 hours on Saturday??

Thanks

Paul

 

[synapsevampire]

Are you intending to count it as 5.5 days per week?

Crystal version?
Database used?
Example data?
Expected output?

How you incorporate the 5 hours seems like a business decision to me, but you might consider breaking it down to hours/8.

One means would be to have a periods table which has attributes about every day, this is common in data warehousing.

Within Crystal you might use a more generic means:

whileprintingrecords;
if dayofweek({table.date}) = 6 then
.5
else
dayofweek({table.date}) < 6 then
1
else
0

Now just sum this field

-k