Forum Discussion
Excel Formula
Hello All, I need some assistance, I have a spreadsheet that I am trying to record accrued paid time off. We are paid bi-weekly so every 80 hours they accrue 2 hours. BUT the max per paycheck is 2...
Patrick2788 thank you for your response, but unfortunately the formula you provided did not work. When I entered 90 hrs worked with the formula you provided the answer still was 2:15. I need it to not exceed 2:00.
Thanks again! If you have any other suggestions I’d be happy to try them. 😊
