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.