Forum Discussion
Solved
I am creating a timesheet for the week. Need to learn how to set a value in a cell.
I want to add up the regular hours for the week and if they work more than 40 hours, i want 40 to appear in the regular totals box and anything above 40 in the OT cell box. How do i do this?
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?
Hi,
I have already sent you with an example file. Can you please look into that? for your reference resending again.