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...
Need Help
  • HotChilli's avatar
    HotChilli
    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 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

You could use Time.FromText() to convert String to Time type:

if [Time]>=Time.FromText("05:00:00") and [Time]<Time.FromText("17:00:00") then "FAIL" else "PASS"

Output:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.