Forum Discussion

New_be's avatar
New_be
Helper V
5 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    New_be Try this:

    Number.Abs(Number.From([Adj_OutTime]) - Number.From([Adj_InTime])) * 24
New_be's avatar
New_be
Helper V
5 years ago

Hi Mr. amitchandak , i try to use the formula, but it still have the problems;

 

 

This is the result;

 

amitchandak's avatar
amitchandak
Super User
5 years ago

New_be , If you have use hour(Adj_hourworked_temp) < 0 and try

or Adj_hourworked_temp <#duration(0,0,0,0)