Hello everybody.
In cell F5 I have the formula '=(D5-C5-E5)*1440/60.
This formula will give me the duration of a work shift.
( D5 = Finish Time C5 = Start Time E5 = Lunch Break.)

In a seperate cell (Say H5) I want to put in general information, (Day off,
Late Shift, etc.) but if that information is "Sick day", I want F5 to
display 7.50 (as in hours) without any start or finish times in the other
cells.

Any help would be greatly appreciated.


Thanking you in anticipation
--
Big Rick