| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP w/ auto calcualting timesheet | Excel Worksheet Functions | |||
| sumif and translate annual hours into weekly quarter hours | Excel Worksheet Functions | |||
| Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
| problem with calcualting | Excel Discussion (Misc queries) | |||
| Pivot table. Calcualting % from subtotals. | Excel Worksheet Functions | |||
Threaded Mode
