tezza
Active Member
- Joined
- Sep 10, 2006
- Messages
- 377
- Office Version
- 2016
- 2010
- Platform
- Windows
- Web
Hi all
Any idea how I go about calculating wages that are based on time rates as per example below.
I'm just not sure how to automatically work it out if the hours go through different pay rates as in D7 through F9
RATE 1 = 9AM - 8PM MON-FRI
RATE 2 = 8PM - 9AM MON-THUR
RATE 3 = FRI 8PM - MON 9AM
Regards
Any idea how I go about calculating wages that are based on time rates as per example below.
I'm just not sure how to automatically work it out if the hours go through different pay rates as in D7 through F9
RATE 1 = 9AM - 8PM MON-FRI
RATE 2 = 8PM - 9AM MON-THUR
RATE 3 = FRI 8PM - MON 9AM
Excel Workbook | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
2 | * | * | * | x1 | x1.25 | x1.5 | * | ||
3 | * | RATE | 6.64 | RATE 1 | RATE 2 | RATE 3 | * | ||
4 | * | * | * | 6.64 | 8.3 | 9.96 | * | ||
5 | * | * | * | * | * | * | * | ||
6 | DAY | START | END | DAY | NIGHT | WEEKEND | TOTAL | ||
7 | Mon | 06:00 | 14:00 | * | * | * | * | ||
8 | Wed | 14:00 | 22:00 | * | * | * | * | ||
9 | Fri | 17:00 | 02:00 | * | * | * | * | ||
Sheet1 |
Regards
Last edited: