Forum Discussion
karina24
Aug 12, 2022Copper Contributor
Formula Error
I am using excel to create a timesheet for my job. There are regular hours, overtime, and double time.
I created an IF function for the overtime (G) but I want to cap the amount at 4 hours. Everything over 4 hours then becomes double time (H). I do not know how to create that cap. As you can see on row 8, the double time is being counted in both overtime and doubletime. I have inserted a picture of the formula I used for the overtime. Is there any way to change it so that it caps out at 4:00 hours? Thanks!
2 Replies
Sort By
- Detlef_LewinSilver Contributor
- karina24Copper ContributorThanks!