calculating the difference between 2 'Time' values

[ya5irha55an]

Hi, I wonder if someone can help me with the following problem:

I have a table with 2 columns,start time and end time, both containing time values in a four digit format, eg 0930 being 9:30am etc.

I have made a query to convert these into the standard format (eg 0930 becomes 09:30), using left/right and & functions.

Now I use the timevalue function to convert the string , eg 09:30m into a recongnised time value.

The problem is now I want to find the difference between the start and end times- but when i try a simple end_time - start_time formule it returns a long number which i dont understand, rather than just giving me the difference betwen the two times.

Im sure there is a simple way to do this which I dont know, can anyone help me out? Thanks in advance!

 

[ajetrumpet]

If you have converted this data into a time format, or your table columns are date/time fields, then you probably will need the DateDiff function. Look at it in the help menu; it gives all of the different intervals on which you can calculate. This include hours and minutes. That will probably work for you here.