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
