Shortcut of Subtracting Times in Power Query

[lastnn30]

Hi

I have Start Time and End Time columns and I want to subtract EndTime - StartTime, in power query. I selected both of them and I know if I go to the Ribbon -->Add Column -->Time -->Subtract

But the Subtract option is not available (or that what I think) if I use the shortcut which is Right Clicking on the Field to see all the option. So my question, how can I do the Subtract using shortcut?

[PhilipTreacy · Accepted solution]

Hi @lastnn30 

If the option isn't there when you right click then you can't do it that way.

Why not just use the Ribbon method?

Phil

[Vijay_A_Verma · Accepted solution]

Right clicking a column offers options from whatever Transformation menu can offer. It doesn't offer options from Add Column menu. Since Transformations menu doesn't offer Subtract time option, hence you can't subtract this way. 

[lastnn30]

Thank you very much.

[PhilipTreacy · Accepted solution]

Hi @lastnn30 

If the option isn't there when you right click then you can't do it that way.

Why not just use the Ribbon method?

Phil

[lastnn30]

I just thought it must be a shortcut for that too. I do not mind the ribbon but it can be confusing sometime and the right click is life saver actually. Thank you very much.