So what i am trying to do is after 40 hours of straight time (not counting overtime). It should make every hour after that overtime. So if you work 9hrs a day mon-fri that would only be 40 straight hours that way on Saturday its all overtime.
Is there a formula or how can i set it up without moving too much? (also is there a way to set up the date to automatically change depending on what month it is? Thanks! Overtime.xlsx
Bookmarks