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.
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.