Maybe this can only be done with VBA? If anyone has an idea how to handle this please post reply. Thanks much!.........

I am trying to figure out how to calculate the time difference (not including weekends and holidays) between two dates and times. I want the time difference ideally to be shown in minutes. If this is not possible then in hours with a resolution of at least 1/10th (i.e. 42.3 hrs) will be fine. The difficult part to this 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 result to be in minutes (or to 1/10th hrs) that I need. Here is an example of my data and manual calculation of the result I am looking for:

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

Manual time difference calculation: 3 Days (not including weekend & holidays) + 12 hrs + 15 min = 4320 min + 720 min + 15 min = 5055 minutes (or 84.3 hrs)

Best regards,
Dan
__________________________________________