Formatting issue when exporting timestamp

[sergio0592]

Hi all,

In my .qvw i have a variation N/N-1. It appears correctly but when i export in Excel, negative value are not formated and appears as number.

I use as expression  =Interval ($(I_value_N) - $(I_value_N_1),'mm:ss')

In QlikView:

In Excel:

Thanks

[Miguel_Angel_Baeyens]

What is the real value displayed in Excel?

[sergio0592]

For row 2 (-20 seconds), it's -0,000234419705586556

For row 5 (-1min and 05 seconds), it's -0,000752718546070723

[zebhashmi]

Hi - you can't show time in Negative (as its a part of Date) Value in Excel you can add in formate if it will work for you

[zebhashmi · Accepted solution]

May be this can help

https://www.extendoffice.com/documents/excel/1423-excel-display-show-negative-time.html

[sergio0592]

Thanks, works with checking  Use 1904 Calendar in Excel options