

Partner - Specialist
2018-12-07
10:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Difference between Time and Interval
Hi guys,
Normally "interval" would give me the same result as "time":
interval(Sum(60*length/[link.curent_speed])/(60*24),'m:ss') time(Sum(60*length/[link.curent_speed])/(60*24),'m:ss')
Recently I've noticed a difference. I got a 48:09 as result for a "time" and -11:50 for "interval".
Do any of you know the difference between the two functions?
Thanks
- Tags:
- functions
3,581 Views
2 Replies

MVP
2018-12-07
11:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It gave you a negative number for interval?
In general Time is what you see in a clock, whereas Interval is duration. Basically, You started at 6 am and ended something at 7 am.... so it took you 1 hour... whereas time is 6 am or 7 am...
Not sure if this was clear enough... but that is how I see it
In general Time is what you see in a clock, whereas Interval is duration. Basically, You started at 6 am and ended something at 7 am.... so it took you 1 hour... whereas time is 6 am or 7 am...
Not sure if this was clear enough... but that is how I see it
3,575 Views


Partner - Specialist
2018-12-11
10:56 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I stil don't know why I would get a negative number for an interval, but I've found out that if I use "time" and the result is bigger than 60 minutes, only the minutes over the 60 minutes get displayed.
E.g.
Interval - Time
14:00 - 14:00
68:00 - 8:00
72:30 - 12:30
3,545 Views
