Forum Discussion

karina24's avatar
karina24
Copper Contributor
Aug 12, 2022
Solved

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!

Resources