Solved Excel if then condition maybe?

December 1, 2015 at 12:54:27
Specs: Windows 7
I have a time sheet and I have separate cells for regular hours and overtime hours. I need a formula that basically says if the sum of cells x,y,z is 40 or more, the 40 goes in the regular hours cell and the remainder goes in the overtime hours cell. Help?

See More: Excel if then condition maybe?

Report •

December 1, 2015 at 20:37:11
✔ Best Answer
Without knowing how your sheet is arraigned, IE Row Numbers & Column Letters,
look here for a very good tutorial on Time Sheets and working with Overtime hours:

Down at the bottom, you can download the example sheet.


message edited by mmcconaghy

Report •
Related Solutions

Ask Question