Sandy,

Take a look at the NETWORKDAYS function, part of the Analysis Toolpak add-in, to account foir the
weekends.

Also, once you can get days, and then multiply by 10, etc., etc. to adjust, to get hours.

If you post specific times and dates, with the expected results of a calculation, then we can help
you more.

HTH,
Bernie
MS Excel MVP


"Sandy" wrote in message
...
Okay, I was able to determine the duration of a Help Desk trouble ticket by
subtracting the received date and time from the closed date and time. Now,
here's the problem. The Help Desk is only open for 10 hours therefore the 24
hour period isn't quite accurate. Also if a trouble ticket extends over the
weekend it also skews the statistics.

Do any "brains" out there have any suggestions? (My brain is fried!) :)

--Sandy