Total time in Hours format

[soniasweety]

Hi all,

I have kpi like

Total Email handle time

I am using the logic is   

sum({<type={'Email'}>}[InteractionDurationSeconds]) 

but I am getting the result like 7.1 M  

but I need the result like     10:45:45   like this   this time is not exact output but my outcome should be like that

Anyone help on this?

Thanks

Sony

[prat1507]

So you're getting the results as total sum of seconds and you want it in HH:MM:ss format, am I right?

Probably this

=time(sum({<type={'Email'}>}[InteractionDurationSeconds])/3600,'hh:mm:ss')

Regards

Pratyush

[tresesco · Accepted solution]

Try using interval(), like:

Interval(sum({<type={'Email'}>}[InteractionDurationSeconds]) , 'hh:mm:ss')