topic Date Time Interval Mathematics in QlikView

Date Time Interval Mathematics

Tue, 18 Jan 2011 04:54:10 GMT

Hi,

I have 4 columns like the following...

Date1 Time1 Date2 Time2
18.01.2011 0100 19.01.2010 0200

and i wanted to create an EXPRESSION to calculate total hrs.

Can someone contribute the formula? [;)]

Thanks.

Date Time Interval Mathematics

deepakk — Tue, 18 Jan 2011 05:07:49 GMT

Hi,

Modify the time1 and time2 field to

time(left(time1,2) & ':' & right(time1,2),'hh:mm') as time1

time(left(time2,2) & ':' & right(time2,2),'hh:mm') as time2

Now time(Sum(time1),'hh:mm') will give you total no of time for time1 field and

time(Sum(time2),'hh:mm') will give you total no of time for time2 field.

Date Time Interval Mathematics

Tue, 18 Jan 2011 07:50:01 GMT

Hi Deepak,

Thanks for your suggestion.

But if i do that, i'll only have the difference of one hr.

In fact, the answer should be 25 hrs because of the date. In the expression, we need to take into consideration of the date if it's not on the same date. That's the tricky part, to me...

Date Time Interval Mathematics

lironbaram — Tue, 18 Jan 2011 08:07:17 GMT

hei

attach is an example of what you asked

hope its helps you

Date Time Interval Mathematics

Tue, 18 Jan 2011 08:14:06 GMT

Hi Nick,

here are a second one.

Good luck!

Rainer