Time Formatting

DevTrev
DevTrev Advocate

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?

Best Answer

  • Bondy_Bo
    Bondy_Bo Contributor
    Answer ✓

    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.