I have an excel sheet that I use to track my time and I am trying to figure out how to cap on certain cells with a max amount and add it to another cell, I am working in time increments so I am not to fluent with how it works.
what I need is to have my total time stop at 40 hours and the remaining time to be placed into the OT cell for overtime. Ex: I worked 43:30 hours this week so I need totals cell to say 40 hours and the OT cell to say 3:30
any help that would be appreciated!
Bookmarks