I've been using this formula to monitor the amount of hours between two dates that have elapsed excluding weekends:

 

 

(
DateDiff ("s", {campaign.date_approved}, {campaign.date_closed}) -
    (DateDiff ("ww", {campaign.date_approved}, {campaign.date_closed}, crSaturday)*24*60*60) -
     (DateDiff ("ww", {campaign.date_approved}, {campaign.date_closed}, crSunday)*24*60*60)
) /60/60;

 

 

But i've now been told that the hour calculations should only apply to working hours 9 to 5. 

 

Does any one know how i would do this?  I was thinking of something like subtracting 80 from the total (16 none workable hrs per day * 5 days) but not sure if this is correct?

 

Any ideas any1?

 

Many Thanks,

Slash.

 

Thanks for the reply.

 

What i'm trying to achive is calculate the number of working hours a campaign has taken to run.  Which i then plot on a graph eg:

 

Campaign X 15hours

Campaign Y 12Hours

 

and so on.

 

 

Example:

 

A campaign could be started on a Wednesday and finish on a Monday.  What i need to sum is the number of 9-5 hours that have elapsed exluding Sat and Sun.

 

Make Any sense?

 

Thanks,

Slash.