Mar 15 2019 02:41 PM
Sorry, my skills with excel are limited, but I'm sure this will be a simple formula for most. Here's what I have and what I'm trying to achieve.
Cells A-E all have a value of "10", representing the total number of hours worked for each day.
Cell F shows that total of hours as "50" ... I'm using =sum(A1,B1,C1,D1,E1)
Cell G shows the total of OT hours as "10" ... =if(F1>40,F1-40,"")
I want cell F to show 40 and still have cell G to show 10.
Mar 15 2019 03:26 PM
Mar 15 2019 06:12 PM
Mar 15 2019 09:19 PM