L
Lamb Chop
I have the worksheet of the employees.
e.g Mary
Date Time start Time finish
12-7-2006 9:00am 6:00pm
13-7-2006 12:00pm 7:00pm
15-7-2006 9:00pm 6:00am
...
etc
I need to calculate the wages. However, it is not that simple because
different working time at different time has rate. For example working from
9am - 6pm will be paid $20 per hour
6pm - 10pm will be paid $22 per hour
10pm - 6pm will be paid $30 per hour
Saturday afternoon, Sunday and public holiday will be at different rates
too.
I have all these rates at another excel sheet.
At the moment, I need to manually allocate the time slot and it is very time
consuming.
Is there any other better way?
Thanks
e.g Mary
Date Time start Time finish
12-7-2006 9:00am 6:00pm
13-7-2006 12:00pm 7:00pm
15-7-2006 9:00pm 6:00am
...
etc
I need to calculate the wages. However, it is not that simple because
different working time at different time has rate. For example working from
9am - 6pm will be paid $20 per hour
6pm - 10pm will be paid $22 per hour
10pm - 6pm will be paid $30 per hour
Saturday afternoon, Sunday and public holiday will be at different rates
too.
I have all these rates at another excel sheet.
At the moment, I need to manually allocate the time slot and it is very time
consuming.
Is there any other better way?
Thanks