how to calculate productivity over hours spent
Thank you so much for your help, It is really helpful to me to avoid earlier
my manual calculations.
Once again thank you.
Balaji
"Gary''s Student" wrote:
If by 13:15 you mean 13 hours, 15 minutes, then:
=B1/(24*C1) should display 528.30
--
Gary''s Student - gsnu200860
"Balaji" wrote:
I have a data like below, where i am calculating productivity on daily basis
for all employees and am spending more tiime on this. Please help me, is
there any formula to calculate productivity per hour.
Emp Production HrsWorked Productivity p/hr
A 7000 13:15 ?
B 6500 11:10 ?
C 6800 12:30 ?
D 7100 10:58 ?
Thanks in advance.
Balaji
|