Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-04-2017, 06:28 PM
christian.calimlim22 christian.calimlim22 is offline Average Processing Time Windows 7 64bit Average Processing Time Office 2010 64bit
Novice
Average Processing Time
 
Join Date: Apr 2017
Posts: 2
christian.calimlim22 is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 04-04-2017, 07:54 PM
Logit Logit is online now Average Processing Time Windows 10 Average Processing Time Office 2007
Expert
 
Join Date: Jan 2017
Posts: 393
Logit will become famous soon enoughLogit will become famous soon enough
Default

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	                ?
Pardon my slowness ... please explain your data above. Specifically, what is ITEM MATCH ?

I'm guessing ITEM MATCH is the total number of units Officer 1 processed in 3 hrs ?
Reply With Quote
  #3  
Old 04-04-2017, 08:19 PM
christian.calimlim22 christian.calimlim22 is offline Average Processing Time Windows 7 64bit Average Processing Time Office 2010 64bit
Novice
Average Processing Time
 
Join Date: Apr 2017
Posts: 2
christian.calimlim22 is on a distinguished road
Default

Hi Logit,

Yes, Item Matched are the number of items a Data Officer was able to match in 3 hours.
Reply With Quote
  #4  
Old 04-04-2017, 11:25 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Average Processing Time Windows 7 64bit Average Processing Time Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,480
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

Something like =C2/B2 and formatted as required?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average Processing Time 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
Average Processing Time Calculate Average Time Elapsed in Days, hours and minutes Nina46 Excel 9 09-11-2015 02:09 AM
Average Processing Time Processing Time Intervals pkrishna Excel 5 09-30-2011 06:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft