Conditional Formatting to hide 00:00 in columnSolved/Closed

Question

Hello,
I would be very grateful if there is somebody who could help me find the solution to what is most likely a simple problem. I don't have a great deal of experience but can usually find a solution by searching google and trying the suggestions others have tried. This time I have come up empty and now have to swallow my pride and ask for help. Any Help would be greatly appreciated and may even help someone else who has a similar problem.
My Problem is;
I have 3 columns Column A start time (hh:mm) Column B finish time (hh:mm) Column C is total Time (hh:mm) where C is (24-A1)+B1 etc 
How can I hide the value 00:00 in column C if there are no values in columns A & B 
I have tried using IFBLANK on Column A 
I have tried using IFBLANK on Column B 
I have tried using IFBLANK on Columns A & B 
I have tried conditional formatting Column C where cells = 00:00 to be White Font 
But so far nothing works any help would be appreciated as I don't like looking at 00:00 I'm lost. 
A B C 
1 22:00 05:00 7:00 
2 00:00 
3 21:58 06:15 8:17 
4 00:00 
5 00:00 
6 00:00

Thank You

venkat1926 · Answer

you cam hide rows or columns in excel
I am not sure whether you can hide individual cells..

sharky9000 · Answer

Hi venkat1926,
Thanks for your reply. I only want to hide those individual cells in column C that have 00:00 as the answer because Columns A & B have no data.
Again Thank you for your answer

TrowaD · Answer

Hi Sharky,

Usually I use IF formula to not show unwanted results of a formula.

In your case I would use:
=IF(AND(A1="",B1=""),"",YOUR FORMULA)

So if both A1 and B1 are empty, then display nothing.
If there is any data in either A1 or B1 then display the result of your formula.

Best regards,
Trowa

Conditional Formatting to hide 00:00 in column

3 responses

Similar discussions

Subscribe To Our Newsletter!