Custom Column - We cannot apply operator + to types Time and Number.

[Qotsa]

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.

[Greg_Deckler · Accepted solution]

@Qotsa You will like have to convert your time to decimal number. https://docs.microsoft.com/en-us/powerquery-m/number-from

[Qotsa]

Thks Greg. That did the trick. 

[mahoneypat]

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