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

# Measure convert to hrs

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.45 1139.45 783.447 1379.58 874.367
• ###### Re: Measure convert to hrs

Maybe remove the Num() function with the '##.##' formatting just leaving something like this

floor( 123456 / 3600 )

• ###### Re: Measure convert to hrs

Not working same result it is giving

• ###### Re: Measure convert to hrs

Use interval function to get results as hours.

interval(ElapsedTime-[Critical],'hh:mm')

Example:

interval('2.5555','hh:mm') or interval('2,5555','hh:mm')  based on your system variables.

Result = 61:19

• ###### Re: Measure convert to hrs

for second expression how can I include the interval?

• ###### Re: Measure convert to hrs

=if(ElapsedTime>=Urgent and ElapsedTime<=Critical,interval(ElapsedTime-Urgent,'hh:mm'),Null())