topic How Can one Multiply Time? in QlikView

How Can one Multiply Time?

Mon, 02 Sep 2013 11:46:38 GMT

Hi there,

I'm faced with a Dilemma that I need to multiply the number of hours and minutes and it's not happening.

For example, TIME('15:30' *2, 'hh:mm'), this calc above gives me 07:00 but I want it to give me 31:00 hours.

Another question: How can one get the duration it took one to solve a request if you have the Request Date(YYYY-MM-DD hh:mm:ss TT)

and the Requst Solvde Date(YYYY-MM-DD hh:mm:ss TT)? Simple getting an interval of the two dates whould give the right answer but now I need to exact duration (The one that excludes weekends, holidays and also excludes after hours(5pm to 8am)).

I hope this is understood.

Re: How Can one Multiply Time?

CELAMBARASAN — Mon, 02 Sep 2013 11:50:00 GMT

Try with interval function

Interval('15:30' *2, 'hh:mm')

Re: How Can one Multiply Time?

Mon, 02 Sep 2013 12:00:53 GMT

Thank you Celambarasan Adhimulam

Re: How Can one Multiply Time?

swuehl — Mon, 02 Sep 2013 12:01:03 GMT

You can find an approach to solve your second issue e.g. here.