# Format duration does not seem to work in visualisations
**URL:** https://discuss.elastic.co/t/format-duration-does-not-seem-to-work-in-visualisations/136068
**Category:** Kibana
**Created:** [June 15, 2018, 9:28am UTC](https://discuss.elastic.co/t/format-duration-does-not-seem-to-work-in-visualisations/136068 "2018-06-15T09:28:45Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@Erik\_M](https://discuss.elastic.co/u/Erik_M)
#### Post date: [June 15, 2018, 9:28am UTC](https://discuss.elastic.co/t/format-duration-does-not-seem-to-work-in-visualisations/136068/1 "2018-06-15T09:28:45Z")
**Ignore post, found the simple mistake: Used the wrong field. If anyone can delete this post please do.**
Hey,
I have a field called metric.time\_delta which is stored as seconds. I would like to display this field as minutes, or "Human readable" called in the format section. I followed the instructions in this thread: [Showing milliseconds as seconds](https://discuss.elastic.co/t/showing-milliseconds-as-seconds/66225) which is exactly what I want to achieve (except seconds-\>minutes instead of millis-\>seconds).
However when I later do a simple aggregations as visualisations the formatting does not work. When i choose to sum on the field "time\_delta" it only shows "a few seconds", but if I sum on the field "metric.time\_delta" it does not format at all and shows the regular sum of seconds. Screenshots below:
 
---
### Author:  [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [June 15, 2018, 2:57pm UTC](https://discuss.elastic.co/t/format-duration-does-not-seem-to-work-in-visualisations/136068/2 "2018-06-15T14:57:34Z")