Windows 10, Office 2016
A1 enter 9/1/2016 0:00 (could be beginning of any month, but must be 12:00 midnight)
A2 enter 9/1/2016 1:00 (advancing one hour at a time)
highlight A1 and A2, click and drag the handle down
the date/time advances one hour at a time through 4 days, but on the 5th day 3:00 turns into 3:59, not 4:00
this happens consistently when begun at 0:00
I know there are alternative ways to create those lists of dates/times, I'm just curious why this is happening
A1 enter 9/1/2016 0:00 (could be beginning of any month, but must be 12:00 midnight)
A2 enter 9/1/2016 1:00 (advancing one hour at a time)
highlight A1 and A2, click and drag the handle down
the date/time advances one hour at a time through 4 days, but on the 5th day 3:00 turns into 3:59, not 4:00
this happens consistently when begun at 0:00
I know there are alternative ways to create those lists of dates/times, I'm just curious why this is happening