Read my signature.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DriverY" wrote in message
...
Hello Bob

I have been trying to e-mail you but without any success. It says that
your
domain name is not recognised.



Here's the time sheet I'm trying to create:



The standard hours of work are 8 hours per day and half an hour unpaid
lunch
break



Operatives begin work at 8:00am and finish at 16:30 thus their 8 hour of
work. They are thus paid for 8 hours work.

However operatives rarely work a 40 hour week and so overtime kicks in.



For the following three hours they are paid at time and a half:

E.g.

8:00-16:30= 8 hours

8:00-19:30= 8 hours + 4.5 (3*1.5 been the time and a half component) =12.5
hours

Thereafter pay is double time

E.g.2

8:00-20:00= 8 hours +4.5 hours (3*1.5 hours) + 1 hour (0.5*2 been the
double
time component) =13 hours



How can I create a formula whereby Excel will differentiate between the
different overtime rates once the 8 hour mark has been passed?



Currently my formula is set up like this, compliments of "Sajay":



D2=Time began E2= Time finished F3=Lunch
break
G4=Hours worked

D3=8:00 E3=16:30
F3=00:30 =E3-D3-F3



G4 has been "Custom Formatted" to hh:mm





N.B Operatives may begin work at 7:00 working until 16:30. In this
instance
their overtime rate would kick in at 15:30 and be paid time and a half for
the remaining hour.



Finally on the occasions where operatives work on a Saturday They are paid
at a rate of 1.5*hours worked for the first 5 hours and then double time
thereafter



On a Sunday it is straightforward 2*hours.



Your help would be greatly appreciated



Kind regards







Tim/ DriverY