Date and Time Intervals

Menu location: Data_Cleaning and Encoding_Date and Time Intervals.

This function enables you to create a column of intervals from a column of dates or times. You must have date or time data in your workbook to do this. The StatsDirect workbook recognises input such as 1/3/67 or 12:55 as dates and times.

You can use this function to work out the distance of each date or time entry from a point which you specify, this point can be a date, a time or a date with a time after it. You must also specify the interval that you want StatsDirect to calculate, this can be years, months, weeks, days, hours, minutes or seconds. Positive intervals represent dates or times later than the reference point which you entered and negative intervals reflect earlier dates/times.

Example

Test workbook (Other worksheet: Event).

To working out the interval in days from a reference point of 1/4/96 to the dates in the following list you can use the "Date and Time Interval" function of the "Data" menu.

Event ----->	Event~Days from 01/04/96
01/03/97	334
02/05/97	396
12/12/96	255
01/11/96	214
03/01/97	277
05/05/97	399
07/08/97	493
08/10/96	190