Forum Discussion
Help with Formula to calculate employee efficiency on specific functions throughout the day
We have employees track their time spent on specific prescribed activities with an Activity Code, Time spent from start to finish on that project, Either the # of units, orders or unique SKU's manipu...
The most likely answer is "by using a table" and one of the many ways to extract values from a table (VLOOKUP, XLOOKUP, INDEX and MATCH, etc). But without being able to see your actual spreadsheet/workbook it's hard to get more specific. Is it possible for you to put a copy of it (no real employee names) on OneDrive or GoogleDrive with a link here that grants access to it?