Cell showing date and time - precision error
 

I have a cell set up as format

dd/mm/yyyy hh:mm:ss

and the contents are 01/01/1995 00:00:00

In the cell below I put 01/01/1995 01:00:00

then fill the cells for a few hundred. After about 200 cells the value shows
as

09/01/1995 10:00:01 - in other words the increment being added for each cell
is slightly greater than the desired one hour. I assume this is a lack of
precision in the cell value. Is there a way of changing this?

I am using Excel 2007.

Grateful for advice.

Cell showing date and time - precision error
 

Enter the first date/time in A1 and in A2 enter:

=A2+TIME(1,0,0) and copy down
--
Gary''s Student - gsnu200908

Cell showing date and time - precision error
 

Sorry:
=A1+TIME(1,0,0)
--
Gary''s Student - gsnu200908


"simonc" wrote:

I have a cell set up as format

dd/mm/yyyy hh:mm:ss

and the contents are 01/01/1995 00:00:00

In the cell below I put 01/01/1995 01:00:00

then fill the cells for a few hundred. After about 200 cells the value shows
as

09/01/1995 10:00:01 - in other words the increment being added for each cell
is slightly greater than the desired one hour. I assume this is a lack of
precision in the cell value. Is there a way of changing this?

I am using Excel 2007.

Grateful for advice.