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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode