yes I could not get the first formula to work. Kept getting reference error. This is a 24 hour cycle so Networkdays really messes me up (at least with my limited bit of working with formulas and functions). daddylonglegs I will try this. The start and end times can be anytime but there is a service level that we provide and we don't count weekends and holiday time against the service level. thanks!