Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Timestamp format

  Hi,       Using Add column I have extracted the time in a seperate column from timestamp, but format is like 0. + 24hr formart time, How to remove 0. from the begining and insert a prope...
Need Help
Tips and Tricks
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Anonymous 

    Please try to change type and select the locale of origin.

    Best Regards,
    Community Support Team _ Eason

danextian's avatar
danextian
Icon for Super User rankSuper User
4 years ago

hI Anonymous ,

 


As tested, 14.52.00 is a text format in Power Query. If you really want the time values to appear this way, you can convert the duration column into text (Text.From), extract the hour, minute and second elements (Text.BetweenDelimiters, etc) and then re-combine them with a period in between each element.