Forum Discussion
Solved
Convert -ve values to +ve values in Power Query
Hi everyone! Wish you all have a very nice day! Based on the image above, i have TimeIn & TimeOut. So i try to get the hours between these 2 times, meaning that TimeOut - TimeIn. So based o...
New_be Try this:
Number.Abs(Number.From([Adj_OutTime]) - Number.From([Adj_InTime])) * 24
New_be , I think because the out time in on next day
if Duration.Hours([Adj_hour_worked]) <0 then [Adj_hour_worked] + duration(1,0,0) else [Adj_hour_worked]
Indeed! It is because the out time is in the next day & vice versa. Thanks!
New_be , In case of the issue, is resolved. Accept all suitable solutions for others to get a similar solution.