=F2-G2-SUM(M2:U2)

--

HTH

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


"dtmd" wrote in message
...
I have a spreadsheet (timesheet) that has a column (F) defaulted to 8. I
need this row to subtract the numbers entered into rows G, M-U only. For
instance - the 8 is regular hours (Column F). If someone takes 8 hours of
Sick leave (column O) - I want the 8 in the Column F to go to zero. If
they
took 3 hours, I want it to go to 5 hours. The other tricky part is that
if
they took 4 hours of Leave Sick (column O) and 4 hours of Leave Annual
(Column M) - both those amounts should be deducted from Column F. Any
suggestions would be great!