Forum Discussion
Smilga2410
Aug 12, 2022Copper Contributor
Working ours
Hello, can you please advise, me what kind of formula should I use, too:
1) Identify individuals, who have worked more than 20 hours/week of overtime (the standard working week for the company is 40 hours?
2) To find out the projects, for which the employees did not work the planned hours?
Example:
- Martin_WeissBronze Contributor
Hi Smilga2410
could you please provide a sample file (without any sensitive data), so it's easier to give a proper advise. And what Excel version do you use?
- Smilga2410Copper Contributor
Hi Martin_Weiss, thank you, Im using Excel 2016