topic Re: Summing time in App Development

Summing time

shakeeb_mohammed — Thu, 19 Jul 2018 14:29:28 GMT

Hi,

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 !

YoussefBelloum — Thu, 19 Jul 2018 14:35:32 GMT

Hi,

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')

kaushiknsolanki — Thu, 19 Jul 2018 14:36:10 GMT

Hi,

Try Interval function to get the time difference.

Load * ,Interval (EndTime-StartTime) as DriveTime

From xyz;

Regards,

Kaushik Solanki