If you specify your requirement in more details, start time, end time, any
excluded breaks etc., I am sure we can come up with something.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Thomas T" <Thomas wrote in message
...
I use Networkdays formula to calculate difference bwtween 2 dates,if the
end
date is beyond 12 hours the formula returns 1, so my calculation of SLA is
going vague.
Is there any formula that we can use which will exclude weekdays and will
report in hours. Or is it possible in vba to do this cutom requirement