A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Cell showing date and time - precision error



 
 
Thread Tools Display Modes
  #1  
Old November 18th, 2009, 02:31 PM posted to microsoft.public.excel.misc
simonc
external usenet poster
 
Posts: 66
Default 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  
Old November 18th, 2009, 03:00 PM posted to microsoft.public.excel.misc
Gary''s Student
external usenet poster
 
Posts: 7,584
Default 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  
Old November 18th, 2009, 03:04 PM posted to microsoft.public.excel.misc
Gary''s Student
external usenet poster
 
Posts: 7,584
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.