Perhaps something like:

=IF(OR(B6=0,B6=7.5),0,B6-7.5)

HTH
Elkar


"Ginny" wrote:

I am doing a time sheet and am having trouble doing IF functions and formulas
for cells.

=SUM((B6-B5)*24,(B4-B3)*24)
=IF(B7=0,"",SUM(B7-7.5))

What I'm trying to achieve is in B7 if B6=0, blank, if B6=7.5, blank,
otherwise B7=B6-7.5

In B7 I want to show overtime or deduct time if less than 7.5 hrs
How do I do this?

Thanks

--
Ginny