We have pulled a Intraday FTP Request file from TRTH via Api to test (PFA).
We need time column in such a way to display actual time ( like 10:00:15 AM) rather than the interval ( 30:00.0).
Could you lets us know how can we achieve this?
588
●14 ●21 ●19
All TRTH extractions will be in .csv format. You need to change the Column C (i.e., the Time column) to HH:MM:SS.000 if opened in Microsoft Excel Format. Since it is a .csv file, Microsoft Excel compresses the format. So please change the Column C format to HH:MM:SS. Below are the steps to get the time stamp in HH:MM:SS format on the TRTH .csv extracted file.
- Select the Time[L] column (Column C)
- Right click on it and select Format Cells.
- Under the ?Number? tab, please select ?Custom? -> h:mm:ss
- If you want the time in HH:MM:SS.000 format, then add .000 at the end of h:mm:ss in the ?Type? window.
By following the above steps, you will be able to view the .csv TRTH extracted file in HH:MM:SS timestamp format.
