#1
|
|||
|
|||
Average Processing Time
Hi All,
I am not sure how I can get the average time spent per item being matched by my associates and I need some help. I apologize if I cant explain it better, here are the data; Data Officer Time Spent (hh:mm) Item Match Average Processing Time Officer 1 03:00 73 ? Officer 2 03:00 109 ? Officer 3 03:00 59 ? Grand Total 09:00 241 ? What i want to know is how many minutes time spent per item being matched by the Data Officer based on hours spent and item matched. Hope someone can help or provide better way of doing it. |
#2
|
|||
|
|||
Code:
Data Officer Time Spent (hh:mm) Item Match Average Processing Time Officer 1 3:00 73 ? Officer 2 3:00 109 ? Officer 3 3:00 59 ? Grand Total 9:00 241 ? I'm guessing ITEM MATCH is the total number of units Officer 1 processed in 3 hrs ? |
#3
|
|||
|
|||
Hi Logit,
Yes, Item Matched are the number of items a Data Officer was able to match in 3 hours. |
#4
|
||||
|
||||
Something like =C2/B2 and formatted as required?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to calculate average time | aymanharake | Excel | 6 | 02-17-2017 04:22 PM |
Batch document processing | SadielCuentas | Word VBA | 0 | 04-19-2016 09:34 AM |
Calculating Average Time across days | lizakay | Excel | 3 | 11-25-2015 05:16 PM |
Calculate Average Time Elapsed in Days, hours and minutes | Nina46 | Excel | 9 | 09-11-2015 02:09 AM |
Processing Time Intervals | pkrishna | Excel | 5 | 09-30-2011 06:24 AM |