5 Replies Latest reply: Jul 31, 2017 1:38 AM by kaan erisen RSS

    Measure convert to hrs

    sony sing

      Hi all,

       

      I have a measures like below all the result showing in  seconds I want to display as hr's   I tried below but not getting the exact result

       

      1) (ElapsedTime-[Critical])   

      2) =if(ElapsedTime>=Urgent and ElapsedTime<=Critical,ElapsedTime-Urgent,Null())

      3)=if(ElapsedTime>=Normal and ElapsedTime<=Urgent,ElapsedTime-Normal,null())

       

       

      I tried like  //=num(floor( (ElapsedTime-[Critical])/3600,'##.##')    how to get exact format  like only I need  1139,1139,783,   like in all 3 expresions how to include?

       

      it is showing 

         

      1139.449167
      1139.451389
      783.4472222
      1379.579444
      874.3669444