- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just use time#() function and multiply by 1440:
=(time#('11:12:13') - time#('10:11:12')) * 1440
- Ralf
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just use time#() function and multiply by 1440:
=(time#('11:12:13') - time#('10:11:12')) * 1440
- Ralf
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This is what I was waiting for. Thank you very very much