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
New_be - Use Number.Abs to get the absolute value. So formula should be:
Number.Abs([Adj_OutTime] - [Adj_InTime])
I try to use this formula;
But i got the error;
New_be Maybe try some spaces? This worked for me
Number.Abs([SampleID] - [Outcome]) * 24Oh, wait, those are date time, hang on.
Greg_Deckler Yess it in a time value😊
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!! 🙂