Forum Discussion
I am creating a timesheet for the week. Need to learn how to set a value in a cell.
Hey Hans,
Thanks for the reply. I have attached my spreadsheet to let you see how i have it set up. What i want is to have the sheet add up all of the regular hours per each staffs timecards. If the value for regular hours is over 40, i want the regular hours cell to show only 40 and the extra hours shown in the OT cell. Can this be done?
Let's say the total number of hours is in cell D10.
Use the following formula for the number of regular hours: = MIN(D10,40)
And for the number of overtime hours: =MAX(D10-40,0)
Hey Hans,
Thanks for the reply. I have attached my spreadsheet to let you see how i have it set up. What i want is to have the sheet add up all of the regular hours per each staffs timecards. If the value for regular hours is over 40, i want the regular hours cell to show only 40 and the extra hours shown in the OT cell. Can this be done?
In AD8:
=MIN(SUM(B8,F8,J8,N8,R8,V8,Z8),40)
Fill down to AD21. In AH8:
=SUM(E8,I8,M8,Q8,U8,Y8,AC8)+MAX(SUM(B8,F8,J8,N8,R8,V8,Z8)-40,0)
Fill down to AH21.
- You are the MAN! Thank you so much for teaching me how to do that. I'm not the most experienced in Excel but, i thought this could be done. Thanks again!