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

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

narband2778 — Fri, 09 Feb 2018 14:07:07 GMT

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 :

After:

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

Thanks in advance.

Naresh

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

Anil_Babu_Samineni — Fri, 09 Feb 2018 14:12:32 GMT

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?

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

narband2778 — Fri, 09 Feb 2018 14:18:26 GMT

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:

Thanks,

Naresh

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

lcontezini — Fri, 09 Feb 2018 14:27:34 GMT

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')

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

narband2778 — Fri, 09 Feb 2018 14:31:24 GMT

Hi,

I have already tried this. No Luck

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

panipat1990 — Wed, 01 Apr 2020 11:46:05 GMT

When we export the data in excel then same problem is coming.it's bug.

Kindly Export the data in csv file.