hi there i am new to this so please dont shout at me,i'm using office 2007.
i'm after an easier way for me to calculate my pay i work odd shifts crossing
over time zones.
what i'm needing is to be able to calculate different pay rates.
i.e
pay rates from 0600 to 1800 are paid at £8 an hour after 8 hours going onto
£12 an hour, after 1800 this goes into night rate of £9 before 8 hours then
goes too £13.50 an hour for remainder.
Example:

14:00 to 03:00 -45 mins break = 12.25 hours, would work out like this
14:00 to 18:00 = 4*£8
18:00 to 22:00 = 4*£9
22:00 to 02:15 = 4.25* £13.50.

also this way round 01:45 to 15:45 running on night rate of £9 until 06:00
then going onto £8 until 8 hours are completed, then overtime of £12 there
after.
is there a simple way well once excel is set up to calculate this, instead
of me taking two hours every friday to work out. ready for monday for that
weeks pay, fed up with my wages always being wrong.