Hi,
I am wondering if anyone has developed a time interval function taking into account that the date is in seperate field. My problem is there is only date field and the upper time value can be from the next day.
For instance the upper time could be 01:00 in the morning and the lower time interval could be 22:50 at night of the day before. The time values are represented in Short Time Intervals. I have tried to calculate the intervals through a query but the results are not displaying correctly. I know of the GetElapsedTime Function from the Microsft Support Pages but I would like to know if anyone has developed something similar to my situation. I would appreciate any assistance.
I am wondering if anyone has developed a time interval function taking into account that the date is in seperate field. My problem is there is only date field and the upper time value can be from the next day.
For instance the upper time could be 01:00 in the morning and the lower time interval could be 22:50 at night of the day before. The time values are represented in Short Time Intervals. I have tried to calculate the intervals through a query but the results are not displaying correctly. I know of the GetElapsedTime Function from the Microsft Support Pages but I would like to know if anyone has developed something similar to my situation. I would appreciate any assistance.
