Excel Question #46

Alex · 02-16-2012, 03:02 PM

I'm not entirely sure of the goal, so is this correct?

1. You enter hours worked on a day on Row 4. If this is 8 hours or less it automatically appears on row 5 as regular hours. If it is more than 8 hours the first 8 hours goes under regular pay and the rest goes under OT. (Not sure what DT is.)

2. Once the total hours in a week reaches 40 hours then all hours after that go to OT.

Is that correct?

02-16-2012, 03:02 PM	#17
Alex . Join Date: Feb 2005 Posts: 13,354	I'm not entirely sure of the goal, so is this correct? 1. You enter hours worked on a day on Row 4. If this is 8 hours or less it automatically appears on row 5 as regular hours. If it is more than 8 hours the first 8 hours goes under regular pay and the rest goes under OT. (Not sure what DT is.) 2. Once the total hours in a week reaches 40 hours then all hours after that go to OT. Is that correct?
	Submit to Quotes