Convert duration to minutes

[#1]

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?

[Anonymous]

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]

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

[#4]

It is in hh:mm:ss now..

[rwunderlich]

I suggest:

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[MarcoWedel · Accepted solution]

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