Forum Discussion

New_be's avatar
New_be
Icon for Helper V rankHelper V
6 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
    6 years ago

    New_be Try this:

    Number.Abs(Number.From([Adj_OutTime]) - Number.From([Adj_InTime])) * 24
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

New_be Maybe try some spaces? This worked for me
Number.Abs([SampleID] - [Outcome]) * 24

Oh, wait, those are date time, hang on.

 

New_be's avatar
New_be
Icon for Helper V rankHelper V
6 years ago

Greg_Deckler Yess it in a time value😊