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

Indeed! It is because the out time is in the next day & vice versa. Thanks!

amitchandak's avatar
amitchandak
Super User
5 years ago

New_be , In case of the issue, is resolved. Accept all suitable solutions for others to get a similar solution.