# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
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?

Tags (3)
1 Solution

Accepted Solutions
Highlighted
MVP

## Re: Convert duration to minutes

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

5 Replies
Highlighted
Valued Contributor

## Re: Convert duration to minutes

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

Highlighted
Valued Contributor III

## Re: Convert duration to minutes

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

Highlighted
Not applicable

## Re: Convert duration to minutes

It is in hh:mm:ss now..

Highlighted
MVP & Luminary

## Re: Convert duration to minutes

I suggest:

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

-Rob

http://qlikviewcookbook.com

Highlighted
MVP

## Re: Convert duration to minutes

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