P Patchcord Board Regular Joined Sep 30, 2003 Messages 73 Dec 2, 2005 #1 I'm calculating time and need a zero result to produce a blank cell instead of zero. Does anyone know how to achieve this?
I'm calculating time and need a zero result to produce a blank cell instead of zero. Does anyone know how to achieve this?
Y yeheya Board Regular Joined May 20, 2004 Messages 162 Dec 2, 2005 #2 Can you explain a bit your requirement with example? Regards, Yeheya
P Patchcord Board Regular Joined Sep 30, 2003 Messages 73 Dec 2, 2005 #3 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.
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.
Y yeheya Board Regular Joined May 20, 2004 Messages 162 Dec 2, 2005 #4 Put the formula like this: =if(SUM(A1:A10)=0,"",SUM(A1:A10)) Regards, Yeheya
fairwinds MrExcel MVP Joined May 15, 2003 Messages 8,638 Dec 2, 2005 #5 Hi, You could custom format cell as e.g. [h]:mm;;
P Patchcord Board Regular Joined Sep 30, 2003 Messages 73 Dec 2, 2005 #6 That's great, thank you very much!