I am adding up employees timesheets.
I have calculated their daily hours. then weekly. At the end of the month I need to know if they have worked more or less than 150 hours that month.
So one week they may have worked only 37 hours and the next week 37.5, by the end of the month an employee may have worked 149.5 hours and I want this to show.
The =150 - ABS() function does not work, if someone has worked over 150 hours it does not calculate correctly.