Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract the hour from a cell showing the date and time | Excel Worksheet Functions | |||
Cell showing the time auto updating | Excel Discussion (Misc queries) | |||
Precision displayed does not match precision in cell | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |