Time Formatting

DevTrev

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?

Bondy_Bo

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.

1. Select the Time[L] column (Column C)
2. Right click on it and select Format Cells.
3. Under the ?Number? tab, please select ?Custom? -> h:mm:ss
4. 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.