Convert Decimal Time to Days, Hours & Minutes in Power BI - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 8
Wendy
Good afternoon.
How can I calculate work hour on Power BI?
For example: date and time start -09/15/2021 07:00 a.m- and date and time process finished -10/15/2021 08:30 a.m-. The duration (result) of this process between this date and time is = 11:30 hours (without count Full 24 hours, just count work time available).
The period of job starts at 7:00 a.m and the end is 5:00 p.m.
reply
Good afternoon.
How can I calculate work hour on Power BI?
For example: date and time start -09/15/2021 07:00 a.m- and date and time process finished -10/15/2021 08:30 a.m-. The duration (result) of this process between this date and time is = 11:30 hours (without count Full 24 hours, just count work time available).
The period of job starts at 7:00 a.m and the end is 5:00 p.m.
reply
Ashley
I would greatly appreciate a video on using Measurements not related to sales. I work with medical data and constantly need to create reports that display people who have had multiple diagnosis or have met several criteria in order to qualify for set services. My data is often provided as a pre-configured pbix file thus I don't have the ability to use Power Query.
reply
I would greatly appreciate a video on using Measurements not related to sales. I work with medical data and constantly need to create reports that display people who have had multiple diagnosis or have met several criteria in order to qualify for set services. My data is often provided as a pre-configured pbix file thus I don't have the ability to use Power Query.
reply
Jing
Thank you so much for sharing Mynda! May I ask how to convert days, hours & minutes to decimal time in Power BI? I got a bunch of data which just show d, h, m, s - -1d, 6h, 30m, 38s- for example. Have no idea how to deal with them... Would be very appreciated if you can make a video of that. Thanks in advance!!
reply
Thank you so much for sharing Mynda! May I ask how to convert days, hours & minutes to decimal time in Power BI? I got a bunch of data which just show d, h, m, s - -1d, 6h, 30m, 38s- for example. Have no idea how to deal with them... Would be very appreciated if you can make a video of that. Thanks in advance!!
reply
Wouter
You can get the same result in Excel with the LET function:
=LET(-
Elapsed_Time; [-Delivery]-[-Pickup];-
days; INT(Elapsed_Time);-
_hrs; (Elapsed_Time - days) - 24;-
hrs; INT(_hrs);-
mins; ROUND((_hrs - hrs) - 60;0);-
CONCATENATE(days; - d -; TEXT(hrs;-00-); - h -; TEXT(mins;-00-); - m-))
reply
You can get the same result in Excel with the LET function:
=LET(-
Elapsed_Time; [-Delivery]-[-Pickup];-
days; INT(Elapsed_Time);-
_hrs; (Elapsed_Time - days) - 24;-
hrs; INT(_hrs);-
mins; ROUND((_hrs - hrs) - 60;0);-
CONCATENATE(days; - d -; TEXT(hrs;-00-); - h -; TEXT(mins;-00-); - m-))
reply
Matt
Hi Mynda, the overview is helpful and the option to download the file is also useful. It may have also been helpful to walk through the code that was -written earlier and pasted in-. That is the heart of the solution.
Regardless, thank you for the video, it is good information...
reply
Hi Mynda, the overview is helpful and the option to download the file is also useful. It may have also been helpful to walk through the code that was -written earlier and pasted in-. That is the heart of the solution.
Regardless, thank you for the video, it is good information...
reply
Eredin
Good but in the it's text, how can I aggregate over those? For example I need the total delivery time for each week. I did the aggregation on the decimal part but I want to display the result in a formatted way as yours. Any help?
reply
Good but in the it's text, how can I aggregate over those? For example I need the total delivery time for each week. I did the aggregation on the decimal part but I want to display the result in a formatted way as yours. Any help?
reply
Multi
I just tried your solution, and it works when its a positive time. But when its a negative time it dosent calculate correct.
By negative time i mean if the decimal number is negative, it calculates wrong time
reply
I just tried your solution, and it works when its a positive time. But when its a negative time it dosent calculate correct.
By negative time i mean if the decimal number is negative, it calculates wrong time
reply
melih
Hi Mynda, thank you, but how can we sum the duration ??? For Example: I need the TOTAL (sum) of hours like : TOTAL = 75:45 (75 hours and 45 Minutes) . I hope you can help !!!!
reply
Hi Mynda, thank you, but how can we sum the duration ??? For Example: I need the TOTAL (sum) of hours like : TOTAL = 75:45 (75 hours and 45 Minutes) . I hope you can help !!!!
reply
Add a review, comment
Other channel videos
9:15
12:16
