time shift and salary calculation

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

"Lamb Chop" <[email protected]> ha scritto nel messaggio
news:%[email protected]...
>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?
>


I think you can find something useful to start:

http://office.microsoft.com/en-us/re...ery=time+sheet

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy