Forum Discussion

anglefbi11's avatar
anglefbi11
Icon for Helper I rankHelper I
2 years ago
Solved

mutliple time format issue

hi dears i am using power query and i am facing a complicated issue with time format. i have a data with mixed 12 hours, 24 format . i need to know how to get them all as the same format . i treid u...
Need Help
  • anglefbi11's avatar
    anglefbi11
    2 years ago

    hi guys

     

    thanks god i found the soulution finally . i changed my regional format in my pc from english UK to English US and it has been solved

amustafa's avatar
amustafa
Icon for Solution Sage rankSolution Sage
2 years ago

Simply change the column data type to Date/Time...

= Table.TransformColumnTypes(Source,{{"DATE", type datetime}})

anglefbi11's avatar
anglefbi11
Icon for Helper I rankHelper I
2 years ago

i did and nothing change.