How to create datediff calculation in Power Query

Question

Is there a way I can use Datediff in Power Query as a calculated column?

This is the calculation I would like to do:

datediff("minute",[Login Time],[Logout Time])

The login time and logout time columns look like this:

I would greatly appreciate your suggestions. Thanks.

Answer 1

You can use the Duration functions. First create the direction:

Duration.From([EndDate] - [StartDate])

Then you can use Duration.TotalMinutes(Durationvalue)