Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I show number of resources by hour in excel?
I have a list of tasks and the time started and time ended. I want to show
by hour how many tasks are being worked with. I have seen this done in a staffing model where you can see number of staff by hour by entering the start and end time, but I can not remember how to creat this. |
#2
|
|||
|
|||
How do I show number of resources by hour in excel?
Here is an example assuming that the start times are in B, end times in C,
and the input times are D1,D2 =SUMPRODUCT(--(B2:B200=D1),--(C2:C200<=D2)) This will give the number of tasks. To get number of staff, you need to say what the correlation between staff and tasks is. -- HTH RP (remove nothere from the email address if mailing direct) "Chris Baker" <Chris wrote in message ... I have a list of tasks and the time started and time ended. I want to show by hour how many tasks are being worked with. I have seen this done in a staffing model where you can see number of staff by hour by entering the start and end time, but I can not remember how to creat this. |
#3
|
|||
|
|||
How do I show number of resources by hour in excel?
Take a look at Pivot tables, you can group date fields into hours with just
a couple of clicks. Regards Ken........................ "Chris Baker" <Chris wrote in message ... I have a list of tasks and the time started and time ended. I want to show by hour how many tasks are being worked with. I have seen this done in a staffing model where you can see number of staff by hour by entering the start and end time, but I can not remember how to creat this. |
#4
|
|||
|
|||
How do I show number of resources by hour in excel?
Say the data is as follows:
Employee Time in Time out A 01:00 05:00 B 02:00 07:00 C 06:00 19:00 I want to see for each hour of day how many employees are on the clock which will allow me to see utilization by hour. I think I may have phrased the original question incorrectly. "Bob Phillips" wrote: Here is an example assuming that the start times are in B, end times in C, and the input times are D1,D2 =SUMPRODUCT(--(B2:B200=D1),--(C2:C200<=D2)) This will give the number of tasks. To get number of staff, you need to say what the correlation between staff and tasks is. -- HTH RP (remove nothere from the email address if mailing direct) "Chris Baker" <Chris wrote in message ... I have a list of tasks and the time started and time ended. I want to show by hour how many tasks are being worked with. I have seen this done in a staffing model where you can see number of staff by hour by entering the start and end time, but I can not remember how to creat this. |
#5
|
|||
|
|||
How do I show number of resources by hour in excel?
I think that you did slightly, but I don't think it changes the solution
greatly. If you just reverse the tests it works as far as I can see =SUMPRODUCT(--(B2:B200<=D1),--(C2:C200=D2)) -- HTH RP (remove nothere from the email address if mailing direct) "Chris Baker" wrote in message ... Say the data is as follows: Employee Time in Time out A 01:00 05:00 B 02:00 07:00 C 06:00 19:00 I want to see for each hour of day how many employees are on the clock which will allow me to see utilization by hour. I think I may have phrased the original question incorrectly. "Bob Phillips" wrote: Here is an example assuming that the start times are in B, end times in C, and the input times are D1,D2 =SUMPRODUCT(--(B2:B200=D1),--(C2:C200<=D2)) This will give the number of tasks. To get number of staff, you need to say what the correlation between staff and tasks is. -- HTH RP (remove nothere from the email address if mailing direct) "Chris Baker" <Chris wrote in message ... I have a list of tasks and the time started and time ended. I want to show by hour how many tasks are being worked with. I have seen this done in a staffing model where you can see number of staff by hour by entering the start and end time, but I can not remember how to creat this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I make the scroll bar show the row number? | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
can excel convert number into words (like 10 to ten)? | Excel Worksheet Functions | |||
Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel | |||
GET.CELL | Excel Worksheet Functions |