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?

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:http://www.cpearson.com/Excel/overt...

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

MIKE

message edited by mmcconaghy

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History