my excell spreadsheet looks like this
colum A 20 peoples names
colum B-H days of week
colum I will calculate total hours worked for employees
with a grand total at the bottom of I
need to calculate hours worked totals without 30 min lunch breaks if hours
worked is over 7.5 hours

so cell B2 would say 9-5:30
need cell B3 to say 8 (as in 8 hours worked with 30 min break)

but part of the problem is that a person can work 7 hours without a lunch
and get paid so we cant take the 30 min break out unless empleyee is over 7.5
hours

the real answer I need in the end is total hours without breaks for full
time and part time people just cant figure out the formula that eliminates
that half hour and a formula that reads 2 times in 1 cell (9-5:30) if I have
to break that part into 2 cells ....so be it... IF ANYONE CAN HELP that would
be great ....been trying to work on it for 3 days