Convert Column from Minutes to Hours

[slounsbury]

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!

[Anonymous · Accepted solution]

Divide ART_Resolved_Actual by 60.

ART_Resolved_Actual_Hour=ART_Resolved_Actual/60.

Am i missing something here , looks so simple 🙂

Thanks

Raj

[slounsbury]

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.

[slounsbury]

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

[Anonymous]

How ART_Resolved_Actual is being calculated ?

Thanks
Raj

[slounsbury]

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

Thanks!