Subtrac Time in Power Query

[Simon_Br]

Hello Comunity,

Actuall i have the challange whit Power Query. I will create a IF-Function.

Example: if [Start]>20:00 and [End]<21:00 then [End]-[Start] else 0

But i become a error message. The Question is, we can i do that?

Greetings,

Simon

[Syndicate_Admin · Accepted solution]

Hi @Simon_Braun 

Your code would like this:

[Start]>#time(20, 00, 0) and [End]<#time(21, 00, 0)

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.