asked on

Calculate Productivity per day in Excel when worked hours, downtime and overtime is given

Day of Week        Average # of wrkd Hours        Average Down Time        Average # of Overtime
Mon        32:56:54        17:02:36        3:13:06
Tue        36:55:00        15:53:48        2:56:30
Wed        37:35:42        16:38:18        3:26:36

Martin Liss

What would you expect the results for Monday to be?

need_solution

ASKER

Productivity of Monday. Is it straight forward as Productivity = (worked hrs+overtime) - downtime?
Or is there any other logic or formula to calculate Productivity?

need_solution

ASKER

Number of Productive hours for Monday

ASKER CERTIFIED SOLUTION

Martin Liss

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Martin Liss

After doing some research, I realize that what you seem to be asking for is just hours worked, while productivity seems to always include some amount of product produced, like cars built per hour or baskets of apples per hour.

Martin Liss

You're welcome and I'm glad I was able to help.

If you expand the “Full Biography” section of my profile you'll find links to some articles I've written that may interest you.

Marty - Microsoft MVP 2009 to 2016
Experts Exchange MVE 2015
Experts Exchange Top Expert Visual Basic Classic 2012 to 2015