question

Upvotes
Accepted
791 9 7 14

Time Formatting

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?

tick-history-rest-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
588 8 13 16

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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea