Anyone know why excel would shift increments on me?
Basically I type a date and a time in a cell:
3/29/18 10:25:08
Then I type a date and time 15 seconds later in the cell bellow
3/29/18 10:25:23
I highlight both cells and hit the little black square to fill the column in till the end of my data set. Part way through I get a single cell with a 16 second increment then it goes back to doing 15 second increments. This happened enough times to shift my endpoint time by five minutes. Why does this happen?
Basically I type a date and a time in a cell:
3/29/18 10:25:08
Then I type a date and time 15 seconds later in the cell bellow
3/29/18 10:25:23
I highlight both cells and hit the little black square to fill the column in till the end of my data set. Part way through I get a single cell with a 16 second increment then it goes back to doing 15 second increments. This happened enough times to shift my endpoint time by five minutes. Why does this happen?
