Have you looked at the functions DayName, DayNumberOfWeek, and DaysBetween?
=( If (DayNumberOfWeek(<Date of Call>) <6) And (<Time of Call> >'8:30' Or <Time of Call> <'17:00') Then Sum(
I stopped here because I realized there are some problems with this, but it may be close to what you need...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.