Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill Date/Time
Hi all, I am using an autofill to fill the date/time in 15 minute intervals. For some reason excel seem to lose a minute when doing this. ie. Jumps from 20/12/05 12:45 to 20/12/05 12:59 and continues from there. I am using a dd/mm/yy hh:mm custom format. But have tried with various date/time formats and have the same problem. I have even tried adding the decimal value (0.0104166 or 0.0104166000019177) and STILL have the same problem! It seems to lose the minute within the first 20-30 cells. If anyone can help me to rectify this, I would really, really appreciate it! Thank you :) Rob -- systemx ------------------------------------------------------------------------ systemx's Profile: http://www.excelforum.com/member.php...o&userid=29254 View this thread: http://www.excelforum.com/showthread...hreadid=494777 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill Date/Time
Hi!
It's a rounding "issue". In your first cell enter a date/time: A1 = 20/12/05 12:00 PM In A2 enter: =A1+TIME(0,15,0) Copy down as needed. Biff "systemx" wrote in message ... Hi all, I am using an autofill to fill the date/time in 15 minute intervals. For some reason excel seem to lose a minute when doing this. ie. Jumps from 20/12/05 12:45 to 20/12/05 12:59 and continues from there. I am using a dd/mm/yy hh:mm custom format. But have tried with various date/time formats and have the same problem. I have even tried adding the decimal value (0.0104166 or 0.0104166000019177) and STILL have the same problem! It seems to lose the minute within the first 20-30 cells. If anyone can help me to rectify this, I would really, really appreciate it! Thank you :) Rob -- systemx ------------------------------------------------------------------------ systemx's Profile: http://www.excelforum.com/member.php...o&userid=29254 View this thread: http://www.excelforum.com/showthread...hreadid=494777 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autofill | Excel Discussion (Misc queries) | |||
date/time stamp | Excel Worksheet Functions | |||
Autofill | Excel Worksheet Functions | |||
More- AutoFill with Non-Seqeuntial Cell References ? | Excel Worksheet Functions | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) |