diference between times

[rcandeo]

I know that has a lot of posts, but I could not find one that helped me really.

I have two time fields, format hh:mm:ss and I only the diference between them in minutes please.

hour2 - hour1 = x minutes

Thank You

[datanibbler]

Hi Robson,

I haven't tried yet, but I guess you can calculate with time_fields just like you can with date_fields,

>>>  hour2-hour2 <<<

Use the TIME() function to specify in which format you want the result.

HTH

Best regards,

DataNibbler

[Anonymous]

Robson

Look like you are in need of the Interval() function.

The interval function formats the expression as a time interval according to the string given as a format-code. If the format code is omitted, the time format set in the operating system is used. Intervals may be formatted as a time, as days or as a combination of days, hours, minutes, seconds and fractions of seconds.

The QV Desktop Help gives a good description of its parameters, after the bit I have pasted in above.

Best Regards,    Bill

[rbecher · Accepted solution]

Just use time#() function and multiply by 1440:

=(time#('11:12:13') - time#('10:11:12')) * 1440

- Ralf

[rcandeo]

This is what I was waiting for. Thank you very very much