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.
