Cant convert more than 24hr - help !

[moshe_Arama2022]

Hello everyone
I have a problem
I pull data from an Excel table into a power Query
In Excel is displayed like this : 36:00 ( hr )
And when it comes to the power Query , he presents it like this: 12:00 ( hr) 

I tried to change by time and by duration, it still doesn't change

I even tried to convert it to text.

  , if you have a solution it would really help me

[v-yalanwu-msft · Accepted solution]

Hi, @moshe_Arama2022 ;

You could add a custom column.

=[Time] - #datetime(1899, 12, 31, 0, 0, 0)

the final show:

Or 

=let _a= [Time] - #datetime(1899, 12, 31, 0, 0, 0)
in Text.From( Duration.Days(_a)*24 +Duration.Hours(_a)) &":"&
 Text.End (Text.From(_a),5)

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[wdx223_Daniel]

M do not support the time type over 24 hours.

you can try to change the type to duration

[moshe_Arama2022]

Hi

I tried it doesn't work looking for some code or something . 

[wdx223_Daniel]

delete the first ChangeType step which is generated by system automatically, then try to change the type manually.

[moshe_Arama2022]

I tried now,  it doesn't work either. 😥