Greetings everybody,
I am using this formula in Cell 'H8' to calculate overtime in a timesheet.
=IF((OR(E8>="",F8>="")),"",IF((I8="Holiday"),(G8),IF((B8=WEEKDAY(6)),(G8),IF((G8>8),(G8-8),("")))))
This works fine with all the conditions except when total hours=8 hours. When it is 8 hours it returns the result as 8.9E-15. I expect a blank cell when Total hours are 8.
Attached here is the sample.
:thanx: