Discussion board where members can learn more about Qlik Sense App Development and Usage.
Can someone help me with the below please?
I have three fields within my data - Vehicle - start time and end time.
the start and end time are in time stamp - e.g. 23:52:25.
What i want to do is sum how many hours a vehicle has been driven.
example data -
I'm using QlikSense.
Thanks in advance !
you can use Interval() function
make sure to evaluate and format your timestamps correctly
it should be something like this:
Interval([End Time]-[Star Time],'hh')
or if your fields are not yet correctly evaluated and formatted on the script:
Interval(Timestamp#([End Time],'hh:mm:ss')-Timestamp#([Star Time],'hh:mm:ss'),'hh')
Try Interval function to get the time difference.
Load * ,Interval (EndTime-StartTime) as DriveTime