Feb 23 2019 09:22 PM
Im new and trying to put in my husbands hours and having anything over 40hrs go into a separate cell so I can have it calculate his pay for OT. I have the cells that I put his hours in, a cell that calulates all of his hours, but I have to manually put his OT hours in the separate cell right now because I have yet to figure out what formula I would use to put anything over 40hrs into the OT cell.
Im doing this as a project to learn more about excel and be able to make my own workbooks. So far this is the only workbook I have created on my own, and this is the only thing Im stuck on. I have already figured out taking out takes and other deductions. Calculated YTD hours and pay. This is literally the only thing Im stuck on. I will take any help anyone can give and use it to learn further, but I need to see the working formula for this one I think. I think maybe Im just overthinking it. Right now Its a very simple workbook.
Thanks so much for anyones help
Abeale1975
Feb 23 2019 10:30 PM