Try
=N((INT(A11)-INT(A10)+1)*8-MAX(HOUR(A10)-9,0)-MAX(17-HOUR(A11),0))
--
__________________________________
HTH
Bob
<Charles Bostic wrote in message ...
Please help create a formula to calculate total hours serviced for a
technician who conducts a service call, which takes him 3 days to
complete. If the start date is 10/20/2009 10:00 a.m. and the service is
completed on 10/22/2009 12:00 p.m., I would like to collect the total
hours in house minus the hours the shop was closed, which is from 5 p.m.
to 9 the next morning. The results should be approx. 18 hours of service.
EggHeadCafe - Software Developer Portal of Choice
CSV Reader in C#
http://www.eggheadcafe.com/tutorials...ader-in-c.aspx