In article <116fue6mhsijo60@corp.supernews.com>, "Jordon" <jordon@REMOVEgrahamtrucking.com> wrote:
<tpf>
>"RompStar" wrote
>> Ok, doing a little project here at work, ok in one of the departments
>> here we have 37.5 hours available for each employee per week...
>>
>> that's after two 15 minute breaks, which is 30 minutes a day, and 2.5
>> hours a week, so 37.5 available and not 40...
>>
>> I have this spreadsheet that tracks what people do and the time it took
>> them to do it..
>>
>> If day Joe Smith, for the week had a total of 30 hours, but he's
>> supposed to have 37.5, that means that 7.5 hours are missing somewhere,
>> that I know how to calculate, but in a percentage, how would that be
>> done.
>>
>> 100% is 37.5
>>
>> if they worked only 30, how would that be calculated using a formula ?
>> if in column:
>>
>> A: available 37.5
>> b: acctual 30
>> c: 7.5 hour deficient
>> d: would show if %
>> so if someone used 37.5, they would be 100% productive..

>Hours worked divided by hours available, formatted as a percentage.
>
>A1 = 37.5
>B1 = 30
>C1 = A1-B1
>D1 = =B1/A1 (81%)
>

Note also ... "productivity" is usually much more than just hours worked or
charged. Perhaps you might call what you are calculating "attendance" ?



Bruce


-------------------------------------
The power of accurate observation is commonly called cynicism by those who have not got it.
- George Bernard Shaw
Cynic, n: a blackguard whose faulty vision sees things as they are, not as they ought to be.
- Ambrose Bierce

Caution ===== followups may have been changed to relevant groups
(if there were any)