lostinexcelformulas
New Member
- Joined
- Apr 10, 2009
- Messages
- 15
I'm struggling with a formula to calculate 3 different rates of pay as part of a timesheet. That being rates of *1, *1.33 & *1.5.
If the employee works normal 8hrs then single rate *1 applies. After those 8 hours working then for a period of 2 hours *1.33 rate applies. After effectively the 8 hours + 2 hours then rate *1.5 applies.
I have one cell displaying total hours, a cell showing hours at *1.33 and a final cell showing anything >2:15hrs. How can go about this problem??
I have tried the limited knowledge that I have to complete this problem but end up going round in circles.
Any ideas. I'm still using Ex'97. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
If the employee works normal 8hrs then single rate *1 applies. After those 8 hours working then for a period of 2 hours *1.33 rate applies. After effectively the 8 hours + 2 hours then rate *1.5 applies.
I have one cell displaying total hours, a cell showing hours at *1.33 and a final cell showing anything >2:15hrs. How can go about this problem??
I have tried the limited knowledge that I have to complete this problem but end up going round in circles.
Any ideas. I'm still using Ex'97. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>