Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am looking for a formula to figure out how many hours an employee worked worked per day i have a date column, a start time column and an end time column my time columns show hours and minutes and if its am or pm. Not sure what formula to use to find hours per day
Solved! Go to Solution.
Hello @jbenson ,
In power query, you can use the function Duration.Hours() to find the time difference in hours between two given times. Sample is below :
In DAX, you can compute the difference between start and end times and then pass that in the DATEDIFF function to get the hours worked. Since there is no date part when you subtract the times, Power BI defaults to 30/12/1899 as the date, which is why I've subtracted the time difference from 30/12/1899 midnight to get the hours value.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos!😊
Hello @jbenson ,
In power query, you can use the function Duration.Hours() to find the time difference in hours between two given times. Sample is below :
In DAX, you can compute the difference between start and end times and then pass that in the DATEDIFF function to get the hours worked. Since there is no date part when you subtract the times, Power BI defaults to 30/12/1899 as the date, which is why I've subtracted the time difference from 30/12/1899 midnight to get the hours value.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos!😊
That worked!
That's great @jbenson . Happy to help!
Please mark this answer as the solution to help others as well!
Really appreciate your kudos!
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
80 | |
60 | |
59 | |
58 |
User | Count |
---|---|
157 | |
119 | |
104 | |
77 | |
69 |