Unable to subtract two columns in the power query

[Deepesh153]

I was trying to subtract two columns with date/time, time datatype on the power query but I selected the desired columns the Date , Time options on the Add Columns Section gets disabled . I don't know what is happening here if anyone can help please 

 I am on the september version 

[Omid_Motamedise · Accepted solution]

In such situation, there are several useuful function.

If you want to calculate the difference of just houre or minute part if two Date.Time use
Duration.Minutes
Duration.Hours
Duration,Second


But if you want to calculate total differnce in hours or minute use
Duration.TotalHours
Duration.TotalMinutes

[Deepesh153]

https://drive.google.com/file/d/10voipz3SMxxKmPu5CMRXYRUVpL2IJsb4/view?usp=drivesdkvideo I don't understand what your are saying but if go to the advanced editor and write the code I am trying to do ,it works 

[Anonymous]

The result of datetime minus datetime is a duration type value. That's why you no longer see the datetime tools. If you want the result to be 12:47:05 AM, then you need to use Duration.TotalDays (not Duration.Days) and then Time.From. So

= Table.AddColumn(PriorStepOrTableName, "Time",  each Time.From(Duration.TotalDays[Subtraction])))

--Nate

[Omid_Motamedise]

Use 

Duration.Days

[Omid_Motamedise]

If this answer helped resolve your issue, please consider marking it as the accepted answer. And if you found my response helpful, I'd appreciate it if you could give me kudos. Thank you!