Hi,

I've done quite well at keeping my name off these boards lately and have
been figuring things out, however, I am pretty stuck with this one.

The situation is that i am making a timesheet, users will enter the time
they start travelling and the time this finish. The time they start on site
and the time they finish. The time they start travelling and the time they
finish. For the first 8 hours they get paid single time, anything above that
they get paid 1.5 time. I need to be able to total the hours for the day,
minus .5 hours (30 minutes) for lunch time and then have the total hours
sorted between the 1x column and the 1.5x column. Therefore the 1x column
should never be more than 8. Not to complicate things further but Travel is
always paid at 1x. I am looking for formulas in the 1x and 1.5x columns (or
maybe just 1x if thats all that is needed).

Example:

A B C D
E F
Travel Start Travel Finish Site Start Site Finsh
Hours 1x Hours 1.5x
08:00 09:00 09:00 18:00
8 1.5
18:00 19:00
1

On the first line there is 10 hours, but the half hour lunch needs minussing
givving 9 1/2 split 8 hours and 1.5 hours. The second line is the travel home
so i single time. It will also need to look at total hours for the day as
someone may visit more than one site, only one half hour should be deducted
though. I think it will probably be better to have a daily total in the 1x
and 1.5x columns instead of trying to get it to work it out as displayed
above on an indiviual entry basis.

A bit of a puzzler indeed :o)

Thanks in advance for any help or guidance you can offer.