Currently i have a roster done where it has start times and finish times for each day and the formula adds up the hours for the week. What i want to do is have a formula that will add the hours together but then subtract the lunch hours or if under a certain amount of hours each day subtract 30mins.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Subtract lunch hours
Similar threads
- Question
