The time format in CSV files are not right in the generated report, how do I view the time in normal format?

1. Right click on the time column, , and choose Format Cell > Customer > dd/mm/yyyy h:mm:ss


2. Another way would be to just click on the cell and check the value as in screenshot below.