Excel export - removing seconds :/

[Anonymous]

Hello! Thank you so much for taking a moment to read my post and potentially help me!

I have created a dashboard, which includes timestamps in the MM/DD/YYYY hh:mm:ss format.  However, when I click export to excel, it cuts off the seconds in some.  Any suggestions on how to keep the seconds?

Thank you!

[marcus_sommer · Accepted solution]

Take a look on the excel-format if it maybe doesn't displayed the second-part and just showed hh:mm.

- Marcus

[Anonymous]

HI,

on the chart dimension, use DATE(data,'MM/DD/YYYY hh:mm:ss')

Best regards,

Cosmina