This worked a treat thank you very much!!!

Can this be edited so I can specify which hours not to count on a weekday
aswell, say 730am til 930am?

Thank you to other suggestions aswell

daddylonglegs wrote:
Assuming B28 and D28 contain both time and date and also assuming tha
these might be on Sundays this formula will give total hours excludin
any time on a Sunday

=INT(D28)-INT(B28)-INT((WEEKDAY(B28-1)+INT(D28)-INT(B28))/7)+IF(WEEKDAY(D28)=1,1,MOD(D28,1))-(WEEKDAY(B28)<1)*MOD(B28,1)

format as [h]:m

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200602/1