Forum Discussion
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...
New_be Try this:
Number.Abs(Number.From([Adj_OutTime]) - Number.From([Adj_InTime])) * 24
I try to use this formula;
But i got the error;
New_be Try this:
Number.Abs(Number.From([Adj_OutTime]) - Number.From([Adj_InTime])) * 24Greg_Deckler Thanks! its solved! 😍
New_be - Cool. Sometimes Power Query really annoys the **bleep** out of me!! 🙂