Forum Discussion
Hours Worked
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
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!😊
3 Replies
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!
