Difference in the Formula calulation
I am a software engineer. We are creating an efficiency report of employees.
we have two reports detail and summary of efficiency of employees.
while calculating detail report we are picking up each jobcard done by an employee . Following is the example
formula applied is as follows
-------------------------------------------------------------------------
Time units *.60 * Punched minutes for the month / Total Punched minutes
--------------------------------------------------------------------------
jobcard nr.| TU |Total punched minutes | Punched minutes for the month| = sold minutes
JC/134638 400*.60 1004 801 = 191
(400*.60*801/1004)
JC/135933 150*.60 117 117 = 90
(150*.6*117/117) ----
(281)
while calculating summary report we are picking up sum of jobcards for each employee. So the above said formula is used on the sum of each component of formula. Example is as follows
400 1004 801
150 117 117
---- ---- ----
550 1121 918
(550*.60*918/1121) =(270)
Can Any one please explain me why this difference is coming of 11 minutes
Between 281 and 270 in spite of using the same formula?