dragging date losing 1 min

[dmheller]

all, when i drag down a date or 2 dates i lose a minute.
So cell B5 has the hard date 1/1/21
Cell B6 has the hard date 1/1/21 1:00
I then highlight the 2 and drag down. you can see when i get down to 1/5/21 when it goes from 3 to 4 am, it doesnt go to 4am it goes to 3:59 any help would be great.

 

[bobsan42]

On my machine it starts building a 10 ms error with each new line after the two fixed ones.
Probably due to rounding.
I would go with a formula (time + 1/24)

 

[shg]

I would use

=mround(b1+"1:00", "0:01")

 

[Marc L]

​

According to Excel behavior try to drag with Ctrl key …​

 

[shg]

I would go with a formula (time + 1/24)

According to Excel behavior try to drag with Ctrl key …

Those will both accumulate the same type of floating-point error, because 1/24 has no exact representation in binary.