Forum Discussion

gusly's avatar
gusly
Helper II
10 years ago

How do display duration properly?

I'm displaying durations in some of my charts. However, I haven't figured out how to do it in a proper way. Currently I'm using a column that represent minutes as a decimal number. Not optimal, si...
Need Help
beerygaz's avatar
beerygaz
Frequent Visitor
9 years ago

This doesn't work for durations lower than 3600 seconds, however, as you end up with 12:mm:ss rather than 0:mm:ss

mcolb88's avatar
mcolb88
Helper III
9 years ago

As a calculated column:

 

VAR Minutes = ROUNDDOWN([CallDurationSeconds]/60,0)

VAR Seconds = ROUNDUP(([CallDurationSeconds] - Minutes*60), 0)

RETURN IF([CallDurationSeconds]>0, CONCATENATE(CONCATENATE(FORMAT(Minutes, "##0"), ":"), RIGHT(CONCATENATE("0", FORMAT(Seconds, "##")),2)), BLANK())

 

And as a formatted measure using the numeric equivalent.

 

Avg Call Duration:= AVERAGEX('Interview Call', [CallDurationSeconds]/60)

 

Avg Call Duration (min):=

VAR Minutes = ROUNDDOWN([Avg Call Duration],0)

VAR Seconds = ROUNDUP(([Avg Call Duration] - Minutes)*60, 0)

RETURN CONCATENATE(CONCATENATE(FORMAT(Minutes, "##0"), ":"), RIGHT(CONCATENATE("0", FORMAT(Seconds, "#0")),2))

 

Could add hours to this as well, but that's pretty far out of range for my application.

 

Hope this helps