Assuming that Kathy is in row 3, the total is in column B, and start/end
times are in C3:L3, try this total formula

=SUM((MOD(COLUMN(C3:L3),2)=0)*C3:L3)-SUM(((MOD(COLUMN(C3:L3),2)=1)*C3:L3))-S
UM(--(IF(MOD(COLUMN(D3:M3),2)=0,D3:M3)-IF(MOD(COLUMN(C3:L3),2)=1,C3:L3)0.25
))/48
it is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Meelikki" wrote in message
...
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?