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

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

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)  Register To Reply

2. ## Re: Do not display calculated cell value (Time format) in timesheet

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))  Register To Reply

3. ## Re: Do not display calculated cell value (Time format) in timesheet

Try

=IF(OR(J6=L6,ISERROR(J6-L6)),"",J6-L6)  Register To Reply

4. ## Re: Do not display calculated cell value (Time format) in timesheet

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

5. ## Re: Do not display calculated cell value (Time format) in timesheet

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

6. ## Re: Do not display calculated cell value (Time format) in timesheet Originally Posted by 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  Register To Reply

7. ## Re: Do not display calculated cell value (Time format) in timesheet

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?  Register To Reply

8. ## Re: Do not display calculated cell value (Time format) in timesheet

Yep...I tried exactly this and it worked...Thank you so much!! Originally Posted by 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?  Register To Reply

9. ## Re: Do not display calculated cell value (Time format) in timesheet  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 