If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|