Skip to main content
Announcements
Discover what’s possible with embedded analytics! March 6, 10 AM ET SIGN UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
rcandeo
Creator III
Creator III

diference between times

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

1 Solution

Accepted Solutions
rbecher
MVP
MVP

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

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

- Ralf

Astrato.io Head of R&D

View solution in original post

4 Replies
datanibbler
Champion
Champion

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
Not applicable

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
MVP
MVP

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

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

- Ralf

Astrato.io Head of R&D
rcandeo
Creator III
Creator III
Author

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