Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generating dates Using Autofill | Excel Discussion (Misc queries) | |||
autofill on fixed dates | Excel Worksheet Functions | |||
Autofill default: I want Fill Without Formatting | Excel Discussion (Misc queries) | |||
autofill next sheet with next set of dates | Excel Worksheet Functions | |||
Can I use AutoFill or a formula to fill a series of letters? | Excel Discussion (Misc queries) |