In this post, we will discuss how to convert Hours into Minutes and add it to the existing Minutes to get a whole number. I tried two different methods and got the same result, so I decided to share it with you.

Let’s walkthrough the steps:

I have a simple table with a Ticket and Time columns. I need to convert the Hours to Minutes and add it to the existing Minutes in the Time column to get a whole number.

Method One

In Power Query Editor, create a Custom Column and add the following formula:

=Time.Hour([Time]) * 60+Time.Minute([Time])

M Query

= Table.AddColumn(#”Renamed Columns”, “Minutes to Resolved”, each Time.Hour([Time]) * 60+Time.Minute([Time]))

Method Two

In Power BI Desktop, create a Calculated Column with the following formula:

Minutes to Resolved2 = HOUR(Ticketing[Time]) * 60 + MINUTE(Ticketing[Time])

Happy reporting 🙂