| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Employee Work Time - Don't Count Duplicates
From a database of customer training appointments, I need to count the time
each employee works each day. One customer is scheduled with an employee at a time. The current formula double-counts overlapping time periods. Current formula: =(SUMPRODUCT((Emp=382)*(Date=4/1/2006)*(Duration)))/60 The data looks like: Emp Date Start time Min. AptID 382 4/1/06 9:00:00 AM 60 123 382 4/1/06 9:00:00 AM 60 123 382 4/106 1:00:00 PM 90 223 382 4/1/06 2:00:00 PM 90 223 382 4/1/06 4:00:00 PM 60 333 382 4/1/06 4:00:00 PM 60 333 210 Total Minutes What formula would keep from double counting the same time period by ignoring subsequent records with the same AptID? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count duplicates once | Excel Discussion (Misc queries) | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Count excluding Duplicates | Excel Worksheet Functions | |||
| Count Duplicates | Excel Discussion (Misc queries) | |||
| count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
Threaded Mode
