DDTC returns the time (in minutes) that the variable meets a specified condition within an hour range. The hour range is set by StartHour and StopHour
SYNTAX:
DDTC(Cx, Comp, Exp, StartHour, StopHour, Time)
where :
Cx is a conditional variable x
Comp or Comparison. Any valid operator such as ">", "<", or "=". Each operator must be in quotations.
Exp is an Expression which is the value used in the comparison
StartHour defines the hour to start gathering data for the calculation, using a 24 hour time designation
StopHour defines the hour to stop gathering data, which includes data to the end of the specified hour
Time is used to set whether the result is in minutes (0) or hours (1)
EXAMPLES:
V80 = DDTC(C72, "<", 3, 8,16, 0) Variable 80 will contain the number of minutes in the time period between 8:00 AM and 4:59 PM that variable 72 is less than 3.00 each day.
V4736 = DDTC(C4728,"<",3,1,2,0) Variable 4736 will contain the number of minutes in the time period between 1:00 Am and 2:59 AM that variable 4728 is less than 3.00 each day, as demonstrated below: