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
|