Hi -

I am trying to create a time sheet that has the start and end times per day,
with total hours scheduled for the week that includes 30 for lunch if they
are scheduled on a particular day for more than 6 hours. Total hours would be
the scheduled time minus 30 minutes for lunch if applicable.

Monday Tuesday
Employee Total Start time End Time Start time End time
Kathy 39.5 8:00 6:00 11:00 3:30
Brad 35.25 9:00 4:00 8:00 5:00

any suggestions?