topic Re: Excel export - removing seconds :/ in QlikView https://community.qlik.com/t5/QlikView/Excel-export-removing-seconds/m-p/1219405#M855732 <HTML><HEAD></HEAD><BODY><P>Take a look on the excel-format if it maybe doesn't displayed the second-part and just showed hh:mm.</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 06 Feb 2017 14:58:11 GMT marcus_sommer 2017-02-06T14:58:11Z Excel export - removing seconds :/ https://community.qlik.com/t5/QlikView/Excel-export-removing-seconds/m-p/1219404#M855731 <HTML><HEAD></HEAD><BODY><P>Hello! Thank you so much for taking a moment to read my post and potentially help me!</P><P>I have created a dashboard, which includes timestamps in the MM/DD/YYYY hh:mm:ss format.&nbsp; However, when I click export to excel, it cuts off the seconds in some.&nbsp; Any suggestions on how to keep the seconds?</P><P>Thank you!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Excel-export-removing-seconds/m-p/1219404#M855731 Anonymous 2020-11-25T16:16:04Z Re: Excel export - removing seconds :/ https://community.qlik.com/t5/QlikView/Excel-export-removing-seconds/m-p/1219405#M855732 <HTML><HEAD></HEAD><BODY><P>Take a look on the excel-format if it maybe doesn't displayed the second-part and just showed hh:mm.</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 06 Feb 2017 14:58:11 GMT https://community.qlik.com/t5/QlikView/Excel-export-removing-seconds/m-p/1219405#M855732 marcus_sommer 2017-02-06T14:58:11Z Re: Excel export - removing seconds :/ https://community.qlik.com/t5/QlikView/Excel-export-removing-seconds/m-p/1219406#M855733 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>on the chart dimension, use DATE(data,'MM/DD/YYYY hh:mm:ss')</P><P></P><P>Best regards,</P><P>Cosmina</P></BODY></HTML> Mon, 06 Feb 2017 15:09:29 GMT https://community.qlik.com/t5/QlikView/Excel-export-removing-seconds/m-p/1219406#M855733 Anonymous 2017-02-06T15:09:29Z