Yes I know these seem to be done to death but I think I have a new
challenge for you!!
I need to create one to ease the burden of myself and my colleague who
have the unenviable task of working on engineers timesheets every
Monday.
Background info -
Monday to Friday
6:00AM - 21:00 is normal time
21:00 - midnight is time and a half
Midnight to 6am is double time
Saturday from midnight until noon is time and a half after this is
double time
Sunday is Double time

Each job the engineer carries out is on a different contract for which
we have to allocate the appropiate hours.
I cannot for the life of me work out the formulas.

Start End lunch total hours normal time/
half double

05:30 11:00 5.50
11:00 12:50 1.83
12:50 13:15 0.42
13:15 16:00 0.50 2.25
16:00 18:15 2.25
18:15 21:00 2.75
21:45 23:00 1.25
23:00 01:30 2.50
My formula in total hours is '=((F14-E14+(F14<E14))*24-G14). The
engineers indicate the time slot in which they take there lunch this
means we accurately deduct the time from the correct contract. I need
a formula to calculate the normal hours (in the first line that would
be 5 hrs and .5 in time/half.

Any takers? Or are you all waving the white flag!!
Please if you can help or need further info mail me.