Forum Discussion
Problems witha time format measure
Hi lbendlin Thanks for the interest, I have a column with time in minutes: registered_time_mins formated as wholenumber
I want to perform a sum of those min, since is the time logged by each worker.
After reading in different places in the community, I realized that Format does not work when the sum is over 24h
I am lookin for a solution that allows me to see per each worker what is the number of hours worked, even perform agregations by department, also be able to calculate averages, but also to format that minutes calculation in a way that is comprehensible by users with a display similar to:
90hour 30min or 90:30:00
second request: Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
