Export to Excel (Time format problem)

[sanderha]

Hello,

I try to export a table box to Excel, but the Time fields aren't exported correctly.

Example: 8:40:00 (in Qlikview) --> -53322,6388888889 (in Excel).

Table Box Properties:

I use Qlikview 11.00.11282.0 and Office 2013.

Is there anyone who can help me with this?

Kind regards,

Sander

[ashfaq_haseeb]

Yes,

Frac did the job.

Have a look at attached application with solution.

Regards

ASHFAQ

[sanderha]

Indeed, Frac works.

Thank you!