I have a small glitch with a conditional formatting formula that I was once told could be solved by rounding. I can not find
the information I was given so I must ask again for this help.
I have a column of times similar to bellow:
I am using conditional formatting to blank out the start and end repeated times as follows.
Cell A2: Cell Value is equal to =A1 (then dark blank out)
Cell A3: Cell Value is equal to =A$1+A2-A3 (then dark blank out)
_______Cell Value is equal to =A2+A3-(A$14+TIME(0,0,1)) (then dark blank out)
Cell A4: Cell Value is equal to =A$1+A3-A4 (then dark blank out)
_______Cell Value is equal to =A3+A4-(A$14+TIME(0,0,1)) (then dark blank out)
...and so on.
When it works properly I would only see the times in cells A1, A3 to A12 and A14.
When the glitch occurs I would see the times in cells A1, A3 to A14.
Because of the 0:00:01 (needed so the
formatting will DARK BLANK Cell A1 and A2) the dark blanking of A13 and A14 sometimes does not work depending on the times in
the cells. Most of the time it works fine, but there seem to be rare situations that the formatting doesn't work.
As I said before there was someone on a board much like this one that told me to ad a rounding function to the formula, but
as with many functions in Excel I'm not fluent enough with it to know how to apply it.