In F5: =IF(H5="Sick day",TIME(7,30,0),=(D5-C5-E5)*1440/60)

--
Ian
--
"Big Rick" wrote in message
...
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