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
Expression.Error: We cannot apply operator + to types Time and Number.
Details:
Operator=+
Left=18:00:00
Right=0.010416667
Both columns dueIn & logIn time are in time format.
Anonymous You will like have to convert your time to decimal number. https://docs.microsoft.com/en-us/powerquery-m/number-from
3 Replies
You can get numbers to evaluate by using Duration.TotalMinutes([duein] - [login time]) for example. You can build your logic around that result.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Anonymous You will like have to convert your time to decimal number. https://docs.microsoft.com/en-us/powerquery-m/number-from
