I have a table with the StartDate (2011/01/29 00:01) and EndDate (2011/01/29 00:05), both these have time in them. My second table I am loading has minutes of the day, eg 00:01, 00:02, etc. What I am trying to do is create an intervalmatch that will give me intervals that the start date and end date fall under. in this call the interval would be 05, as in that transaction happened in the 5 minute interval.
I am using this to check intervals when people sing in and out of the building.
Check with the interval function and create a separate field for this Interval(EndDate-StartDate,'hh:mm') as somefield name same as the field that you need to classify using the second table you will get the difference in minutes.
If you want to convert a time to an interval - like a lookup - then you should use the class function in the script. And you should perhaps use it for both StartTime and EndTime. Depends on what to you want to display if StartDate belongs to one interval and EndDate belongs to another...
Intervalmatch is used when you have times in one table and the intervals defined in a second table and you want to link them both.
The Interval function that Celambarasan points at is used if you have time spans that you want to format as intervals in minutes.