
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Elapsed Time Calculation
Hello !
I have 2 timestamp fields like this :
- Start Date and Start Time
- End Date and End Time
I need to calculate the elapsed time, in Seconds, amongst those TimeStamp pairs.
How do I do that ?
Thanks in advance for your support !
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try checking this out:

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try this if fields are in pure time stamp fields.
Interval( [End Time] - [Start Time],'s' )
Or
Interval( [End Time] - [Start Time],'ss' )
Regards
Anand


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
also possible:
(EndTimeStamp-StartTimeStamp)*86400
meaning: difference of the timestamps in days * seconds per day
hope this helps
regards
Marco

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks 4 your help !
I have solved the issue.
Here are some lines showing the concept on a standalone script (QVW) of mine that I use as a 'laboratory' :
LET INTERVALO=INTERVAL(MAKEDATE(2015,01,15)-MAKEDATE(2015,01,01),'D hh:mm');
TRACE $(INTERVALO);
Thanks again !
