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 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.
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 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.