Working ours

New Contributor

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?










2 Replies

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?

Hi Martin_Weiss, thank you, Im using Excel 2016