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?

 

Example:

Smilga2410_0-1660292414939.png

 

 

 

 

 

 

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