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 Maybe try some spaces? This worked for me
Number.Abs([SampleID] - [Outcome]) * 24
Oh, wait, those are date time, hang on.
Greg_Deckler Yess it in a time value😊