Zero result = Blank cell

[Patchcord]

I'm calculating time and need a zero result to produce a blank cell instead of zero.

Does anyone know how to achieve this?

 

[yeheya]

Can you explain a bit your requirement with example?

Regards,
Yeheya

 

[Patchcord]

Yes, I'm just adding up hours worked ie:

=SUM(A1:A10)

If no hours are worked, the result is zero. I need the cell to be empty if no hours are worked.

 

[yeheya]

Put the formula like this:

=if(SUM(A1:A10)=0,"",SUM(A1:A10))

Regards,
Yeheya

 

[fairwinds]

Hi,

You could custom format cell as e.g.

[h]:mm;;

 

[Patchcord]

That's great, thank you very much!