Hi All,
I am trying to calculate the amount of time it takes to process help desk
tickets. I have used the NETWORKDAYS formula but it only returns whole days.
Therefore, if a ticket is logged at 5:25 PM on Monday and completed at 8:00
AM Tuesday the NETWORKDAYS is 2. I would like to be able to input date and
time started and date and time ended and have the calculation return days,
hours, minutes. Of course I need it to skip weekends and holidays like the
NETWORKDAYS formula.

Any help woudl be appreciated. A bonus calculation woultd be to exclude non
work hours.

Thanks