Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need Help with Correct Formatting

Hi all,    I am having an issue when trying to run this power query. I have a query that converts my date time column, to military time (i.e. 13:00:00). I am trying to get this query to work, but i...
  • HotChilli's avatar
    4 years ago

    A time will be 

    #time(hour as number, minute as number, second as number)

     "05:00:00" is a string.

    That should be enough to get you a little further