I created a spreadsheet which contains the date and the hour
I load into Qlik and display in a straight table & for some reason 59 min 59 sec are added. For several hundred rows it is showing the data as the excel, but then it started adding these additional minutes and seconds.
What makes you think it's the table? Did you check the underlying data (e.g. by using the Search option on this field)? Is there any manipulation done to the field when it's loaded or displayed? Is the data actually as displayed in Excel or is Excel's display setting overriding data that includes a timestamp with more details?
