Forum Discussion
Custom Column - We cannot apply operator + to types Time and Number.
Hi, Having no luck modifying this formula to get around the error. = if [Cancelled] = 1 and [logIn time] <= [dueIn] + 1/24 * .25 and [logIn time] >= [dueIn] - 1/24*.25 then 1 else 0 Expr...
Anonymous You will like have to convert your time to decimal number. https://docs.microsoft.com/en-us/powerquery-m/number-from
Greg_Deckler
Community Champion
Community ChampionAnonymous You will like have to convert your time to decimal number. https://docs.microsoft.com/en-us/powerquery-m/number-from
Thks Greg. That did the trick.