| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number of tasks completed in a specific time frame
In column C, add the following formula:
=HOUR(B1) Then, add a Pivot Table (see http://peltiertech.com/Excel/Pivots/pivotstart.htm) where the employee names are in the "row" section, the hours of the day are in the "column" section, and you count instances of each hour in the body of the table. "Robert" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number of tasks completed in a specific time frame
Unfortunately I can not access that site due to company security. But thank
you for trying to help. -- Robert "BekkiM" wrote: In column C, add the following formula: =HOUR(B1) Then, add a Pivot Table (see http://peltiertech.com/Excel/Pivots/pivotstart.htm) where the employee names are in the "row" section, the hours of the day are in the "column" section, and you count instances of each hour in the body of the table. "Robert" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
