LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCF PCF is offline
external usenet poster
 
Posts: 1
Default How do I get AutoFill to fill dates with time without rounding.

I've run into a problem when using autofill in Excel. I'm trying to autofill
dates in the following format dd/mm/yyyy h:mm:ss. For example, I have a
measurement time of

02/10/2008 12:28:00
and the next time is:

02/10/2008 12:28:15

I've highlighted both of these cells and then dragged the bottom corner to
autofill this pattern. This works for awhile until I get:

02/10/2008 12:40:29
instead of
02/10/2008 12:40:30

This doesn't make a big difference right away but after continuing this for
a couple of hours the time is way off.

Is Excel all of a sudden rounding this number? Is there a way of making it
so that exactly 15 seconds are added each time? Any help would be greatly
appreciated!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Generating dates Using Autofill Peter Iredale Excel Discussion (Misc queries) 4 June 19th 07 01:53 PM
autofill on fixed dates Guido Cole Excel Worksheet Functions 1 March 18th 07 04:23 PM
Autofill default: I want Fill Without Formatting Frustrated by Autofill Excel Discussion (Misc queries) 0 January 9th 07 03:39 PM
autofill next sheet with next set of dates Penny Excel Worksheet Functions 0 July 11th 05 09:25 PM
Can I use AutoFill or a formula to fill a series of letters? tadpgk835 Excel Discussion (Misc queries) 3 April 28th 05 02:46 PM


All times are GMT +1. The time now is 01:38 AM.

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

About Us

"It's about Microsoft Excel"