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
3 21:58 06:15 8:17