Formatting of a duration value

[sqpdln]

Given a field 'duration' containing either seconds or milliseconds as a numerical value, it would be good to have a way of formatting it as hh:mm:ss.

• The numeral.js lib used to format numbers in Kibana has a "time" formatting option, but it's not implemented for use on Number fields in kibana
• Moment.js doesn't seem to have a way of removing the time zone offset, so storing duration as a Date field doesn't work either

[martinhynar]

I was hoping for this for 4.1.0 and found out just today that it is not there (in 4.1.1). So sad. This would be really appreciated enhancement for 4.1.2

[ghost]

Add to this for microseconds as a numeric field type too, and for formatting to use something like Grafana's automatic scale. So 1000000 us = 1s

[tbragin]

Looks like there was a duration formatter added in #6499

@bevacqua Does it address what is being requested here?

[bevacqua]

Yes, it should cover the vast majority of use cases

[anhlqn]

I guess this feature is available in 5.x.x alpha?

[tbragin]

@anhlqn Yes, duration field formatter is available as part of 5.0-alpha1.

Closing as dup of #5130