I would like to set up a timesheet with the format listed below. I've tried
a couple of formulas, but I haven't found anything that works.

Day Date Start End Lunch Total
Sick/Vacation
Monday 03-02-2005 8:00 17:00 45 8:15 0:00
Tuesday 03-03-2005 0:00 00:00 0 0:00 8:00

I would then like to add the Total column. This gives me my time for
overtime calculations. Then add the Sick/Vacation column separately.
I can do it with Start and End times, but when I try to subtract Lunch, it
stops working.

Thanks for the help.