Hello Excel Geniuses!
I am in need of some help to get the brain juices flowing on this Monday morning. Here's the scoop:
I have created a time card calculator to calculate total time worked and distribute it to regular and overtime hours. Currently I have it set to calculate if over 8 hours then add the remaining as overtime, seems simple enough. This works for a day by day basis but I also need it to run against a running total of 40 hours per week. Meaning if more than 40 hours worked, then add all remaining entries as overtime.
I have tried creating an additional column to calculate the running total and then doing a simple if/then to return a 0 if under 40 or a 1 if over 40. But I am stuck in trying to do a nested If/then to check for the 40 hours before checking for the 8 hours. I've attached the spreadsheet so you can look under the hood. Can anyone PLEASE help point me in the right direction???
Many thanks!
Bookmarks