im building a time sheet and i need some help
I have a Range that has all my hours worked B3:B17
I work 7 hours a day
if i work over 7 hours i want it to count the Number of hours im over (if i work 10hours one day and 8 hours the next i want it to count 4)
also it cant lower the number if i only work 6 hours eg. =SUM((B3-7),(B4-7),....)
cant seem to get it to work
Bookmarks