Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time Intervals
I received a raw dataset with samples occurring in five minute intervals.
There were no start and stop times accompanying them. Is there a function in Excel that can start at say 1/1/05 00:00 and then go 1/1/05 00:05 and then 1/1/05 00:10 and 1/1/05 00:15 and so on. This way I will not have to manually enter these dates for five mintue intervals over the course of one yesr of samples. Thanks in advance. Chris |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time Intervals
Hi!
One way: Assume the dates/times are to be entered in column A, starting in A1. In A1 enter: 1/1/2005 00:00 In A2 enter: =A1+TIME(0,5,0) Drag copy down as needed. NB: You would think that you could series-fill but this won't work! Try this: Enter in A1 1/1/2005 00:00 Enter in A2 1/1/2005 00:05 Select both A1 and A2 and "grab" the fill handle and drag down. After 1/1/2005 8:15 the fill generates a rounding "error" and the next increment is 1/1/2005 8:19. Biff "ChrisM" wrote in message ... I received a raw dataset with samples occurring in five minute intervals. There were no start and stop times accompanying them. Is there a function in Excel that can start at say 1/1/05 00:00 and then go 1/1/05 00:05 and then 1/1/05 00:10 and 1/1/05 00:15 and so on. This way I will not have to manually enter these dates for five mintue intervals over the course of one yesr of samples. Thanks in advance. Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time sheets | Excel Worksheet Functions | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
Time To Leave | Excel Discussion (Misc queries) | |||
Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions |