Forum Discussion

slounsbury's avatar
slounsbury
Icon for Helper II rankHelper II
8 years ago
Solved

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!

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      slounsbury
      Icon for Helper II rankHelper II
      8 years ago

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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        How ART_Resolved_Actual is being calculated ?

         

        Thanks
        Raj

    • slounsbury's avatar
      slounsbury
      Icon for Helper II rankHelper II
      8 years ago

      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.