Forum Discussion
Solved
HOUR/MINUTE values
Hello everyone, I have a question for you I have to calculate the response time of a service. I achieve that by obtaining the difference of two fields of a table. (end of service time - service star...
This is not an uncommon problem. There are lots of issues with duration essentially. See these articles:
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279
How about Format([number of hours]/24,"hh:mm") - haven't tested for numbers larger than 24 - But for smaller numbers this should work based on my limited understanding of Microsoft Date numbers it should work