SYNTAX:

TOD(Interval_Minutes,Offset,StartTime,Format)

IntervalMinutes: The number of minutes to add to the StartTime for each number added.

Offset: The number of interval_minutes you want to add to starttime.  Offset of 1 is the first time period, 2 is the 2nd...  It can be positive (to get times in the future) or negative (to get times in the past).

StartTime: A string representing a valid time (i.e. "08:15", "14:30", "2:30 PM", a cell reference to a cell containing a time, or a function that returns a date/time string (such as DSORT)

Format: Date Format (i.e. mm/dd/yyyy...) for the date returned by the function. 

EXAMPLES:

Start date of report is 8/1/2008.

TOD(1,1,"08:00","m/d/yy hh:nn:ss") returns 8/1/08 08:00:00 - Inteval_Minutes of 1, offset of 1 means first 1 minute period (ie same as the starttime).

TOD(1,2,"08:00","m/d/yy hh:nn:ss") returns 8/1/08 08:01:00 - Inteval_Minutes of 1, offset of 2 means second 1 minute period after starttime.

TOD(15,3,"09:00","hh:nn") returns 09:30:00 - Inteval_Minutes of 15, offset of 3 means 3rd 15 minute period after starttime.

TOD(C4,D4,"08:00","hh:nn") returns 07:50 - Where C4 = 5 and D4 = -1.