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

Report
Posts
3
Registration date
Saturday December 6, 2014
Status
Member
Last seen
December 7, 2014
-
 Sharky9000 -
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

3 replies

Posts
2599
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 24, 2020
401
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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4001 users have said thank you to us 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
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
you cam hide rows or columns in excel
I am not sure whether you can hide individual cells..
Posts
3
Registration date
Saturday December 6, 2014
Status
Member
Last seen
December 7, 2014

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