| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of tasks completed in a specific time frame
I have a list of employees in column A. Their name may appear multiple times
within that column. In column B I have a list of times they completed a task in the format mm/dd/yy hr:min (but all on the same date). I have a finite list of all the employess (rows) and all the hours of the day (columns) in a grid format. I need to create a formula that will tell me for each hour of the day, how many tasks were completed by each employee. Is this possible? -- Robert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| How to automtically increase a number every time a file is used | Excel Discussion (Misc queries) | |||
| avoid retype the number more than one time withen acolumn | Excel Discussion (Misc queries) | |||
| Number of employees in the appropriate time column | Excel Worksheet Functions | |||
| how do i convert a number into minutes for a time of completion c. | Excel Discussion (Misc queries) | |||
Threaded Mode
