Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert duration to minutes

I have a measure "Total Causal Time" and it is displayed in duration format, is there a way to convert this to straight cumulative minutes?

1 Solution

Accepted Solutions
MarcoWedel

Hi,

maybe by changing the Format Pattern in the Number tab of your chart properties to "m" or by multiplying your measure with 1440 and format as Integer (number 1 representing 1 day, 24h or 24*60=1440 minutes):

[Total Causal Time] * 1440

hope this helps

regards

Marco

View solution in original post

5 Replies
Anonymous
Not applicable
Author

Hi


please let me know 'Total Causal Time' is in seconds or hours or days ?


if it is in seconds


Total Causal Time'/60 will give you minutes


Total Causal Time'/(60*60) will give you hours

or


please post a sample data or scree shot


MindaugasBacius
Partner - Specialist III
Partner - Specialist III

I am not 100% sure if this is your case. It sounds like that

For minutes:

time([Total Causal Time] / 1440) as Time

For seconds:

time([Total Causal Time] / 86400) as Time

Not applicable
Author

It is in hh:mm:ss now..

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I suggest:

Interval( Interval#([Total Casual Time], 'hh:mm:ss'), 'm')

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

MarcoWedel

Hi,

maybe by changing the Format Pattern in the Number tab of your chart properties to "m" or by multiplying your measure with 1440 and format as Integer (number 1 representing 1 day, 24h or 24*60=1440 minutes):

[Total Causal Time] * 1440

hope this helps

regards

Marco