Forum Discussion
Stewart_Sherwood
Sep 01, 2022Copper Contributor
Calculating overtime rates.
Hello, I'm trying to find a formula to determine overtime. If I'm entering start and end times the pay rate changes at certain hours. For example: Midnight to 5am is 1.5x standard rate 5am to...
- Sep 01, 2022
There was a slight error in the attachment to my previous reply (not in the formula but in the end times), so I have updated it.
HansVogelaar
Sep 01, 2022MVP
See the attached demo workbook.
- Stewart_SherwoodSep 01, 2022Copper ContributorThanks for that, should be easy enough to add into my spreadsheet when I get time!
- HansVogelaarSep 01, 2022MVP
There was a slight error in the attachment to my previous reply (not in the formula but in the end times), so I have updated it.