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 - Cool. Sometimes Power Query really annoys the **bleep** out of me!! 🙂