none
Date format like 56:16.4 RRS feed

  • Question

  • I have imported a log file into an excel sheet and one of the columns is the date and time of the event.

    It is in the format as 56:16.4 and I have not idea how to get that to date and time format.

    Any suggestion?


    Gary


    • Edited by gehrenfeld1 Tuesday, October 11, 2016 12:07 PM
    Tuesday, October 11, 2016 12:06 PM

Answers

  • It is in the format as 56:16.4 and I have not idea how to get that to date and time format.

    Seems that this string did not contain a date, it's only a duration.
    The format is mm:ss.0 means 56 minutes 16.4 seconds.

    Andreas.

    • Marked as answer by gehrenfeld1 Tuesday, October 11, 2016 1:12 PM
    Tuesday, October 11, 2016 1:09 PM

All replies

  • It is in the format as 56:16.4 and I have not idea how to get that to date and time format.

    Seems that this string did not contain a date, it's only a duration.
    The format is mm:ss.0 means 56 minutes 16.4 seconds.

    Andreas.

    • Marked as answer by gehrenfeld1 Tuesday, October 11, 2016 1:12 PM
    Tuesday, October 11, 2016 1:09 PM
  • Step 1: Check your source data. What file format is it? How does the data formatted in these files?

    Step 2: Check your source. That format may be a time offset. Some files use a formatting like

    1 2016-10-11 10:12:13.0 Process started
    2 00:00.5 Reading data
    3 00:12.5 Reading more data
    

    to save space.

    Tuesday, October 11, 2016 1:14 PM