Employee overtime

[Ben H]

Hi

Please can you let me know how to calculate employee overtime costs/gender/job/job family/department etc in excel.
How do i best visualise this in terms of charts and kpis?
Is there a method in excel by which i can present a summary of results found from the analysis?

Thanks

 

[vletm]

Ben H
Case 'Employee overtime' ...
There are millions of rules for overtimes.
You should know rules,
which You would need or should to use with Your calculation.

 

[Ben H]

Hi

Please can you help with the attached.

Thanks

 

[vletm]

Ben H
Okay ... now, there is a file.
Is there all needed rules? ... my opinion is that no!

You would manually fill expected results.
Do those samples cover all cases?