Convert seconds into numeric value

[#1]

Hello All,

I have a expression which returns the 119 seconds:

Interval((Sum(TOTAL{<FirstAgent={'<>0'}>}conv)/Count(TOTAL{<FirstAgent={'<>0'}>}ID)/Count(DISTINCT(Date))) +(Sum(TOTAL{<FirstAgent={'<>0'}>} wrap)/Count(TOTAL{<FirstAgent={'<>0'}>}ID)/Count(DISTINCT(Date))),'ss')

Now I have to convert that 119 secs into 119 as a number so that I can continue my formula.

Any idea how I can do it.

Thanks,

Hasvine

[MindaugasBacius]

Divide all the expression by:

(24*60*60)

[avinashelite]

Try like this

NUM(

Interval((Sum(TOTAL{<FirstAgent={'<>0'}>}conv)/Count(TOTAL{<FirstAgent={'<>0'}>}ID)/Count(DISTINCT(Date))) +(Sum(TOTAL{<FirstAgent={'<>0'}>} wrap)/Count(TOTAL{<FirstAgent={'<>0'}>}ID)/Count(DISTINCT(Date))),'ss')

)

[#4]

Hi Avinash & Mindaugas,

Unfortunately, I do not get the right answer.

Thanks,

Hasvine

[tresesco · Accepted solution]

Multiply your expression by: (24*60*60)

[avinashelite]

You need it in the NUM format or what is the output your excepting ?? could you please explain us the same with an example ? so that it will help us to understand

[#7]

Thanks Amit.

It works.

KR,

Hasvine