Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Shahzad_Ahsan
Contributor II

How to multiply amount with time

He everyone

I need to calculate 'Result' filed.

Result = Time * Amount

Convert the time in minutes.

Time(HH:MM)AmountResult
3:4514.23195
1:303.65328.5
0:354.25148.75
0:5612.59705.04
1 Solution

Accepted Solutions

Re: How to multiply amount with time

=Time#([Time(HH:MM)],'hh:mm')*24*60 * Amount

4 Replies

Re: How to multiply amount with time

=Time#([Time(HH:MM)],'hh:mm')*24*60 * Amount

amijit_hazarika
New Contributor III

Re: How to multiply amount with time

Hi Manish,

This will definitely work. But wanted to know if the below would work too?

=Time#([Time(HH:MM)],'hh:mm')* 3600 *Amount

Re: How to multiply amount with time

NO... you are 3600 <> 24*60

3600 can be used when you have hour field and you want to convert to second.

I mean when you have Amount per second.

Shahzad_Ahsan
Contributor II

Re: How to multiply amount with time

Hi Manish

Thanks for your answer

This is working fine.....

Community Browser