Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |