Time Intervals

[ChrisM]

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

 

[Biff]

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