Forum Discussion
Formula for OT totals
Hello everybody, I have been charged with creating and maintaining a spreadsheet to track our employees OT, however, I am struggling to correctly create the necessary formula to calculate the OT tot...
MoreSassyThanSavvy Not sure what A100 refers to in your formula and I don't believe you need SUMIF. Perhaps the attached workbook will point you in the right direction. The formula in column M, sums the numbers of hours greater than 8 for each day. If the hours on a particular day are below 8, then zero is returned for that day.
Riny_van_Eekelen Thank you so much! This template has been exceptionally helpful.