Conditional Formatting to hide 00:00 in column [Solved/Closed]

sharky9000 3 Posts Saturday December 6, 2014Registration date December 7, 2014 Last seen - Dec 6, 2014 at 07:11 PM - Latest reply:  Sharky9000
- Dec 8, 2014 at 02:48 PM
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
See more 

4 replies

Best answer
TrowaD 2392 Posts Sunday September 12, 2010Registration dateModeratorStatus July 16, 2018 Last seen - Dec 8, 2014 at 11:16 AM
1
Thank you
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

Thank you, TrowaD 1

Something to say? Add comment

CCM has helped 1705 users this month

Good morning TrowaD (it's 05:23 here in Australia),
I want to say a BIG THANK YOU (I know I'm Shouting) your solution was simple, elegant and best of all it worked. Once again thank you for your help. I knew the solution would be something simple as it usually is but as you become frustrated searching and trying answers without success you fail to see the simplicity and look for the difficult.
Thank you
Sharky9000
venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus July 30, 2015 Last seen - Dec 6, 2014 at 11:23 PM
0
Thank you
you cam hide rows or columns in excel
I am not sure whether you can hide individual cells..
sharky9000 3 Posts Saturday December 6, 2014Registration date December 7, 2014 Last seen - Dec 7, 2014 at 01:33 AM
0
Thank you
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