Do Not Show Value If Empty (1 Viewer)

[.Justin]

I have a sheet that tracks incidents and I need to work out how long between the incident occuring and how long it has taken for it to be reported, ensuring it's within our KPI etc.

However I have the following forumla: =((F2+G2)-(B2+C2))*24 which does what I want it to do, however what I would like it to do is only show the number of hours when there is data in the date / time cells. But I cannot work out how to do this.

 

[Ranman256]

In a other field,have it look at the date field and see if its empty for a true/false value.
Filter on the true.

=(F2="")

 

[NBVC]

You can use =SUM() to let you know if all 4 cells are blank...

e.g.

=IF(SUM(B2,C2,F2,G2)=0,"",((F2+G2)-(B2+C2))*24)

 

[boerbende]

I thouth also about the solution proposed by NBVC. Although this might lead to copy paste text / number issues with Excel (when necessary)
You can also use the conditional formal (value = 0 , then text color = white for example)

 

[NBVC]

or you can use custom format to hide 0's..


Format Cells|Custom|0;-0;;@