SYNTAX:

HOUR(VarNum,Offset, Date_Format, future)

VarNum:  The variable number to get the value for.

Offset: Number of slots for the variable type from the start date of the report to get data for.  For example, if the start date is 1/1/2000 and the offset is 2 the value for the 2nd data slot will be returned.  I.E.  Offset of 2 for a 15 minute variable the date/time for the 12:15 AM to 12:30AM slot will be returned.  

Date_Format:   Date Format (i.e. "mm/dd/yyyy hh:mm"...) to return date/time in. 

Future:  Parameter is not used at this time but is requied for function to work.  Set to 1.

NOTES:

Use Locate, Daily Detail Values to place this formula. 

EXAMPLES:

HOUR(1031,4,"hh:mm",2) - returns "00:45", the date/time of the 4th slot for variable 1031.  If no data exists in the slot for variable 1031, returns the start date/time of the slot.  If data does exist, returns the date/time that value has been entered with (i.e. "00:49")