Thread: Time Intervals
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ChrisM
 
Posts: n/a
Default 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