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

[narband2778]

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

[Anil_Babu_Samineni]

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?

[narband2778]

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

[lcontezini]

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]

Hi,

I have already tried this. No Luck

[panipat1990]

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

Kindly Export the data in csv file.