Do not display calculated cell value (Time format) in timesheet

[kocco]

Hi guys...

once again I would be really happy if someone could help me...

I have timesheet, there is TIME IN and OUT and calculated hours...then it calculate overtime...but I need to hide zero value in overtime cell...I§ve tried couple of formulas but nothing works for me... does anyone has a clue how to do this..

Here is sample timesheet timesheet_ex.xlsx (green is display, red is hide)

Thanks in advance

[DGagnon]

Try this, your values of 0 are not equal to exactly 0, so you need to check for anything less than a very small value

=IF((J6-L6)<0.0001,"",(J6-L6))

[Bob Phillips]

Try

=IF(OR(J6=L6,ISERROR(J6-L6)),"",J6-L6)

[DGagnon]

Use Bob's solution, i forgot to account for the error factor.

[kocco]

Thank you for reply...but my excell is giving me error in formula...actually in both...

[kocco]

Thank you for reply...but my excell is giving me error in formula...actually in both...

I'm sorry guys...Bob's solution works!!!! Great...THANK YOU

[DGagnon]

are you getting an error while entering the formula? this could be regional setting, try this:

=IF(OR(J6=L6;ISERROR(J6-L6));"";J6-L6)

if that is not the solution, could you please share the error?

[kocco]

Yep...I tried exactly this and it worked...Thank you so much!!

are you getting an error while entering the formula? this could be regional setting, try this:

=IF(OR(J6=L6;ISERROR(J6-L6));"";J6-L6)

if that is not the solution, could you please share the error?

[DGagnon]

No problem, could you please mark this thread as solved?