~~~ Distinguishing Normal; X1.5 and X2 Hours throughout the week by what day and time they are worked ~~~
 

I am trying to set up a time sheet.
I have looked at some Excel samples but i cannot find any to suit my needs
as yet.

I Have an Excel Sheet designed, but am having a little trouble working out
how to SET the weekday Hours of :
Mon-Fri 7:30AM - 3:30PM as NORMAL TIME (This is a 8hr time frame, but is
paid as 7.6hrs, dur to the minus of a lunch Break)
Mon-Fri the 1st (3) hrs in excess of the above NORMAL hrs are paid at TIME &
HALF (1st 3hrs worked on a SATURDAY are also TIME & HALF)
Any other hours outside of the above times are paid at DOUBLE TIME

If i can manage to get some assistance i would like this sheet to be coded,
to avoid having complex CALULATIONS, and the chance of them being accidently
modified.

To make things a little more confusing, i need more than one (1) RATE,
depending on a Cell Value.
This is because if an employee is working on certain sites he then must be
paid a higher rate of pay.
Worked hours in general sites his/her rate remains the same.

I need to set up a sheet for each employee as each employee is on a
different base rate due to skill levels.

Basically i need some assistance witht the code to break up the Start and
Finish Times each day into the Correct pay categories, these could be:
NORMAL TIME (1)
TIME & HALF (1.5)
DOUBLE TIME (2)
SITE RATE NORMAL (1) )
SITE RTE TIME & HALF (1.5) These rates will need to
be identified by a Cell Value of say [SITE;WORSHOP]
SITE RATE DOUBLE (2) )


Any help is appreciated, either with CODE setup or Formulas if i must go
that way.

Regards

Corey