Hi

In cell E2 =MIN(10,((D2-B2)*24-C2))
In Cell F2 =MAX(0,((D2-B2)*24-C2-10))
In cell H2 =E2+F2
Copy down range as appropriate. Format cells E2:H17 to 2 places decimal.

Regards

Roger Govier


jongyrocka wrote:
Hi Guys,
I'm sure the question has been asked from time to time, but this one
has got me a bit stumped, and looking at other peoples questions, just
confuses me even more!

so basically I just wanna be able to enter times say from
0600 am till 1953 with a .5 lunch break

Basically what I want from this, is a cell for normal hours up to 10, a
cell for overtime hours after 10 and a total.

i've managed to get a total, and overtime hours, but not normal hours!

Then for the totals
I want a cell that works out normal hours (which should always be 76
anyway)
another cell that works out time and half (which is normal time that
goes over 76)
and another cell that works out the double time.


Sounds a bit weird, but basically we usually do long days...we get
double time after 10 hours in a day. and time and half after 76hrs in a
fortnight..

I have a copy of mytimesheet of what i've achieved so far, so if anyone
could maybe help me, download it, edit it, and maybe mail it back to me
would be awesome!
with any suggestions!!


Cheers
Nico


http://members.iinet.net.au/~nico69/time_sheet.xls