Hello,
I would appreciate if someone could help me. I am trying to figure out how to calculate the time that has passed (not including weekends and holidays) between two dates and times. I need a resolution of at least 1/10th of an hour. If the elapsed time calculation is in minutes this would be fine also. The difficult part is I do not want the weekends and holidays included in the calculation. I know about the Networkdays function but haven't been able to get the 1/100th hr (or minutes) resolution that I need. Here is an example of my data and what I hope to calculate:

Start Date/Time: 12/28/04 1:30 AM

End Date/Time: 1/4/05 1:45 PM

Holidays: 12/29/04, 12/30/04

Time elapse calculation: 3 Days (not including weekend & holidays) + 12.25 hrs = 72 hrs + 12.25 hrs = 84.25 hrs (or 5055 minutes)

If anyone knows how to get the above answer with Excel Functions you know your stuff. I have been trying to figure this out for days. I hope someone can help. Thank you!!!

Best regards,
Dan