cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
slounsbury Helper II
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_ActualART_Resolved_Actual_Hour
0 0
3005
1121.86
2564.26
85414.23
420.71

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
rajendran Resident Rockstar
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

View solution in original post

5 REPLIES 5
Highlighted
rajendran Resident Rockstar
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

View solution in original post

slounsbury Helper II
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.

 

Capture.PNG

rajendran Resident Rockstar
Resident Rockstar

Re: Convert Column from Minutes to Hours

How ART_Resolved_Actual is being calculated ?

 

Thanks
Raj

slounsbury Helper II
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!

slounsbury Helper II
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.

Helpful resources

Announcements
New Ranks Launched March 24th!

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!

‘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

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

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