Forum Discussion
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 on that simple calculation, i got the hours worked values. But some of the value have -ve sign. I just want to know how many hours worked & i just want to ignore the -ve values. So how can i do that? Thanks in advance 😊
New_be Try this:
Number.Abs(Number.From([Adj_OutTime]) - Number.From([Adj_InTime])) * 24
12 Replies
New_be - Use Number.Abs to get the absolute value. So formula should be:
Number.Abs([Adj_OutTime] - [Adj_InTime])I try to use this formula;
But i got the error;
New_be Maybe try some spaces? This worked for me
Number.Abs([SampleID] - [Outcome]) * 24Oh, wait, those are date time, hang on.
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]
