Forum Discussion
Solved
Negative hours
Hi folks. I’m trying to figure out a solution to calculate hours worked on our time sheets. We have an entry for each day, with an in time and an out time on a 24-hour clock. The issue I’m having is ...
Thank you both for your suggestions. What eneded up working for me was using a custom colmn
Duration.TotalMinutes(#time(0,0,0)+([End Time]-[Begin Time])-#time(0,0,0))
I found this answer on another post on here.
https://community.powerbi.com/t5/Desktop/Negative-Duration/m-p/250515#M111195
In this case I think you need to use a datetime column, not just the time component when calculating the hours.