productivity formula

**sccottt** · 11-06-2009, 07:59 AM

hi im trying to work out the productivity of employees based on how many hours they work (Time in Back Office). How many pieces of work they complete(Back Office items Completed) if 1 piece of work should take 7 mins.
the item in red is what i cant seem to figure out any help would be greatly appreciated.

ive included an example

thanks Scott

**DonkeyOte** · 11-06-2009, 08:08 AM

Not really very clear... Productivity in terms of what ?

Perhaps:

H26: ="00:07"/H24

ie which would equate to 8% of expected given your sample results (ie 100% would be around 65 completed items given time worked)

**sccottt** · 11-06-2009, 08:28 AM

thanks for the quick reply. productivity as in items completed in the time they have been logged in given that it should only take 7 mins to complete one item. e.g a person is logged in to the system for 1 hr and completes 1 piece of work so 100% of there time is taken on this one piece but it should only take them 7mins to complete so in 1 hour technically they should have completes roughly 8.5 pieces. hopefully this makes sense

i thought it would be average per case / 7 mins * 100 but i keep getting ridiculous figures. appreciate the help thanks

**DonkeyOte** · 11-06-2009, 08:32 AM

I'm still curious though as to why the earlier example is not correct... ie what is the result you expect to see ?

If you changed time to 00:35 the formula would return 100% ... ie they completed 5 items which equates to 100% of the items expected.

If you subsequently revert time worked to 07:30 you get 7.78% ... ie they completed 5 items out of the expected 64.28571 items - aka 7.78%

**sccottt** · 11-06-2009, 08:41 AM

appologies id entered your origional formula incorrectly. thank you for you help its been driving me mad all morning, was unaware i could put time into a formula like that so thanks

**DonkeyOte** · 11-06-2009, 08:42 AM

was unaware i could put time into a formula like that so thanks

generally speaking "00:07" is not a time value however the act of division coerces the time string into a time (number).

**vivekmartin** · 10-01-2010, 01:39 AM

Hi,
I just joined this forum and it's nice to have a place to get support.
I am in the process of preparing a time sheet for my company and kind of got lost with the efficiency and productivity formulas (attached).
I am sure I've missed something here. Any help would be much appreciated.
Cheers!

**arthurbr** · 10-01-2010, 06:58 AM

Vivekmartin,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.