Hey on your sample file I created something.įor this, I first created a new column inside Power Query based on the column "Regular Hours" using the transformation "Total Seconds", the idea behind this, is to have a column that contains seconds. I did try to tweak this but got nowhere either. I also need to be able to sum these values for a matrix. But, 26.98 is not correct at 5 hours and 59 minutes. It was good enough until someone wanted to know how long was 16.33 really. This gives me the decimal value in the Duration column of the table above. So, when I split the hours and minutes, I have to redo the minutes and multiply by negative one if the hours are negative and positive 1 if they aren't. This is done to correct work entries that were entered incorrectly. There are instances of hours being negative. I decided to split the time into hours and minutes. There are a few instances that go over 24 so PBI has an issue converting it to time. My original problem is that I have a column of labor hours in my table. Solved: Convert from decimal to duration (HH:MM:SS) - Microsoft Power BI Communityīut then I realized it hadn't.
0 kommentar(er)
