Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

narband2778
Contributor II

Trying to Export to Excel but Minutes are converting to hh:mm:ss

Hello Everyone,

Trying to Export below Number of minutes Filed from straight table to Spread Sheet but this converts into hh:mm:ss as shown below:

Before :

1.png

After:

2.png

How can I avoid this and output result should be in mins.

Thanks in advance.

Naresh

Tags (2)
4 Replies

Re: Trying to Export to Excel but Minutes are converting to hh:mm:ss

I never come this type of issue while exporting? Can you show image exactly how Straight table looks like? Have you applied any Format condition to achieve in minutes?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
narband2778
Contributor II

Re: Trying to Export to Excel but Minutes are converting to hh:mm:ss

Hi Anil,

This is expression for "Avg LOS in mins"

=Interval(Avg(Date(LeftDeptDateTime, 'DD/MM/YYYY  hh:mm:ss') - Date(ArrDateTime,'DD/MM/YYYY  hh:mm:ss')), 'm')

Below is the Straight Table:

1.png

Thanks,

Naresh

Partner
Partner

Re: Trying to Export to Excel but Minutes are converting to hh:mm:ss

I'd try your expression inside num, like:

num(

Interval(Avg(Date(LeftDeptDateTime, 'DD/MM/YYYY  hh:mm:ss') - Date(ArrDateTime,'DD/MM/YYYY  hh:mm:ss')), 'm')

,'#.##0')

narband2778
Contributor II

Re: Trying to Export to Excel but Minutes are converting to hh:mm:ss

Hi,

I have already tried this. No Luck