Forum Discussion
Solved
Help with IF formula please
I am creating a spreadsheet to help me calculate our staff's payroll. I need a formula to help me work out the standard pay and overtime. So what I want excel to do is- If the hours in cell A1...
Thanks! Your values are not a number of hours such as 41, but a time value such as 41:00
With a total time in E9, the formula for regular hours is
=MIN(E9,40/24)
and the formula for overtime is
=MAX(E9-40/24,0)
Format the cells with these formulas as [h]:mm
HansVogelaar here is the spreadsheet so far. Thank you SO much for your help.
Thanks! Your values are not a number of hours such as 41, but a time value such as 41:00
With a total time in E9, the formula for regular hours is
=MIN(E9,40/24)
and the formula for overtime is
=MAX(E9-40/24,0)
Format the cells with these formulas as [h]:mm
- Hi! Pls check my question: https://techcommunity.microsoft.com/t5/excel/please-help-me-with-formula-in-excel/m-p/3518804
- Fantastic!!! That has sorted it. Thank you SO much!!
