View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Charles Bostic Charles Bostic is offline
external usenet poster
 
Posts: 1
Default Calcualting hours

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