Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello !
I have 2 timestamp fields like this :
I need to calculate the elapsed time, in Seconds, amongst those TimeStamp pairs.
How do I do that ?
Thanks in advance for your support !
Try checking this out:
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
also possible:
(EndTimeStamp-StartTimeStamp)*86400
meaning: difference of the timestamps in days * seconds per day
hope this helps
regards
Marco
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 !