Calculate the number of Business Hours between two date / time fields

[AdrianRutter]

Can anyone advise me how I might progress this issue.

I have played with DateDifff and can get the Total Number of Hours, but obviously this will include overnight time, when our helpdesk does not operate...!?!?!?!?! Adrian Rutter
Consultant - UK

 

[MichaelRed]

Not much to go on here, so my response will be likewise sparse.

I would approach this by having one recordset hold the dates/times of operation for the business (Help Desk?). This would basically be the open and close date/time values for the entit/object. Depending on the specifics, it may be on an individual, group, whole department or other sub-division, which could, in turn dictate additional fields and/or record entries. I would then set up the other part to just hold the normal start and end date/time values for the entries (Calls/requests?). to determine the "Work Hours" between the statr / end, just calculate (DateDiff is ONE way to do this - but it does limit the interval). Then, for the same start & end, calculate the "Holiday Hours" as the time NOT included by the unit responsible and subtract from te total / overall hours between start / end.

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over