Crossing Midnight | Message 2 of 20 | TechRepublic

Discussion on:

Three tips for rounding Excel time values

View entire thread

Message 2 of 20

Next » « Prev

4 Votes

+ -

Crossing Midnight

I believe that's for when you cross midnight. Take out the +($B2>$C2) parts and watch what happens to the 3/19 values. (Spoiler: It blows up.)

Posted by mckinnej

17th Aug