in C3 put:

=(B3-C3)*24 to convert time to decimal hours e.g. 7:30 ==7.5 and format
cell as general

in D3

=If(C34,C3-0.5,C3)

HTH


"Chris" wrote:

I calculate the number of hours daily worked. I have column A: timeIn, Column
B: TimeOut, Column C calculates the total hours done, which is fine. I am
trying to enter a formula in column D which will say something like this: If
the number of hours in column C is greater than 4:00 hours, then 30 minutes
have to be substracted to it.
How can I do this?
I have tried : IF(C3Time(4,0,1), "-0:30"), to no avail.
Any help appreciated.