Have noticed a strange little one. Not sure if its a bug, or perhaps I’m misusing a formula or two (which as many here would attest, is not beyond me! )
So take a look at this calendar. Look at the times presented. Some are on the hour, but many end times are a second early. All the data associated involves start times and durations, and all the durations are either a whole number of hours or half hours. (so for example 1.5 hrs)
What could be causing this?
Here’s example data in my table:
And here’s the cal