cancel
Showing results for
Did you mean:
Helper II

## Convert Column from Minutes to Hours

Hi All,

I have a column that I created through a mesuare that add two columns but it is in minutes instead of hours which I need for comparision reasons. I found several different ways to do this on the forum but was confused on how to actually impliment it.

Here is what I am wanting to do. The column in bold is what I am hoping to accomplish.

v_rpt_service Table

 ART_Resolved_Actual ART_Resolved_Actual_Hour 0 0 300 5 112 1.86 256 4.26 854 14.23 42 0.71

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resident Rockstar

## Re: Convert Column from Minutes to Hours

Divide ART_Resolved_Actual by 60.

ART_Resolved_Actual_Hour=ART_Resolved_Actual/60.

Am i missing something here , looks so simple 🙂

Thanks

Raj

5 REPLIES 5
Highlighted
Resident Rockstar

## Re: Convert Column from Minutes to Hours

Divide ART_Resolved_Actual by 60.

ART_Resolved_Actual_Hour=ART_Resolved_Actual/60.

Am i missing something here , looks so simple 🙂

Thanks

Raj

Helper II

## Re: Convert Column from Minutes to Hours

Unfortunatly It doesn't appear to be that simple. I also ran the forumla you posted with the same result.

Resident Rockstar

## Re: Convert Column from Minutes to Hours

How ART_Resolved_Actual is being calculated ?

Thanks
Raj

Helper II

## Re: Convert Column from Minutes to Hours

ART_Resolved_Actual = CALCULATE(SUM(v_rpt_Service[Minutes_Waiting])+SUM(v_rpt_Service[Resolved_Minutes]))

Thanks!

Helper II

## Re: Convert Column from Minutes to Hours

What I ended up having to do was dividing both columns by 60 that were used to create the calculated column (ART_Resolved_Actual) and then re-add them which worked.

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors