Tags: appear, column, completed, employees, excel, frame, microsoft, msdn, multiple, number, software, specific, tasks, time

Number of tasks completed in a specific time frame

On Microsoft » Microsoft Excel

2,604 words with 2 Comments; publish: Thu, 22 May 2008 19:03:00 GMT; (306125.00, « »)

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

All Comments

Leave a comment...

  • 2 Comments
    • 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

      #1; Thu, 22 May 2008 19:04:00 GMT
    • 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

      #2; Thu, 22 May 2008 19:05:00 GMT