From decimal number to type time

[Wilm117]

Hello,

I'm struggling with this seeminly simple issue, but i cannot get it fixed. I am analyzing the amount of hours that a bus drives. From my export i get my data in decimal numbers, but i want to transform this to minutes using the type "time". However, when I give this command I get errors.

in another table i did this too, but the decimal numbers were way lower (e.g. 0,0479) and here could change to type Time without any problems. Does anybody know why this happens and how i can solve this? I already tried some formulas from other posts in the community, but i can't figure it out..

Thanks!

[parry2k]

@Wilm117 in the first image, first you have converted the column to decimal type and then you are converting it to time, the step on which this column is converted to decimal, change that to time and it should work.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[negi007]

@Wilm117  can you share your sample data in text format which can be copied here. seems like some non-numeric or data conversion issue.