Hi Jason

Thanks for this. Not quite worked.

I tried it and have:

start time end time total1 start lunch end lunch total2 Grand Total Excess R/Total
08:00:00 17:00:00 09:00:00 13:00:00 13:30:00 00:30:00 08:30:00 -8.50 -8.19

so total1 is the hours worked

total2 is the total lunch break time

I'm subtracting total2 from total1 to get Grand Total

excess should be 07:30 (the daily contracted hours) minus Grand total

and R/total would be a running total for the week.

I hope this is now a bit clearer.

I'm off out for the night now, but will check this out tomorrow and try again.

Thanks again, much appreciated

Steve



On Tue, 24 Mar 2009 12:04:56 -0700 (PDT), jasontferrell wrote:

Change the "Excess" time to display a number of hours instead of a
time format. Negative time formats won't work.
The formula in "Excess" would be something like:
=((end time)-(start time)-[(end lunch)-(start lunch)])*24
Then change the format for this cell to "General" or "0.00".