Forum Discussion

Smilga2410's avatar
Smilga2410
Copper Contributor
Aug 12, 2022

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_Weiss's avatar
    Martin_Weiss
    Bronze 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?

    • Smilga2410's avatar
      Smilga2410
      Copper Contributor

      Hi Martin_Weiss, thank you, Im using Excel 2016

Resources