awesome...thank you for your quick response!

"Bob Phillips" wrote:

I should have added that the cell should also be formatted as [h]:mm

--

HTH

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


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