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...

Charting

excel

Formulas and Functions

redstar1318

Copper Contributor

Jan 05, 2023

mathetes The formula I have for accrued time is hours worked multiplied by 0.025.

ex: 80:00*0.025=2:00

ex: 75:00*0.025=1:52

ex: 63:39*0.025=1:35

ex: 90:00*0.025=2:15 **but would like to cell to read 2:00

**The max accrued per paycheck is 2:00. If an employee worked 90hrs they will still only accrue 2:00.

If I enter my formula for 90hrs into excel it would be 90:00*0.025=2:15. But as stated they are only allowed to accrue 2:00 per check. There for I would like that cell to read 2:00.

I have the cells set up as followed;

F1 - hours worked

G1 - hours accrued (which currently has the formula, F1*0.025) and would like this cell to have a max total of 2:00 but to be able to show totals under 2:00.

Please let me know if that explanation was any better.

Thanks for your help!