Forum Discussion
Time format export data from hours to decimal
In query editor. Select the column and split it by deliminator
You get two columns. 1 is hours, 1 is mins
New column = hours + (mins/60) = decimal number and works with values over 24 hours.
KISS
I dont know where to put that string?
crossing threads a bit but back to your earlier post.
What I actually want is a column that has up until now been in decimal hours. so 2.5 hours etc.
i think it would still work as hh:mm. But I am getting lost when I have done what you said. My column is now a duration in power query. When I close the editor the first entry is 11 hours and my table value is 0.45
So that looks to be in a day format. How do I change this. Note I am using a roll back to Dec version as Febs is no good for csv imports
playing further in query editor
I made it a duration as discussed. I just went to transform and clicked on make sum of hours.......returns a decimal value of each row that at first glance looks correct......this might be my solution. will just interogate
no its incorrect values. not the solution. 109hours output turned in to 13.3 hours so its miles off