# Create new field value is incorrect
**URL:** https://discuss.elastic.co/t/create-new-field-value-is-incorrect/326912
**Category:** Elasticsearch
**Created:** [March 3, 2023, 7:02am UTC](https://discuss.elastic.co/t/create-new-field-value-is-incorrect/326912 "2023-03-03T07:02:06Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@ikonrao](https://discuss.elastic.co/u/ikonrao)
#### Post date: [March 3, 2023, 7:02am UTC](https://discuss.elastic.co/t/create-new-field-value-is-incorrect/326912/1 "2023-03-03T07:02:06Z")
Hi,
I have a field which has value in seconds.
I need to view it in hours. I used create new field and used script to convert it into hours.
What i have observed is it is not able to take decimal values. For example, if the value in seconds is 600, the script convert it into 0.00 hour instead of 0.16 hour.
Does anyone has idea what needs to be done to get exact value
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [March 7, 2023, 10:54pm UTC](https://discuss.elastic.co/t/create-new-field-value-is-incorrect/326912/2 "2023-03-07T22:54:34Z")
It'd be great if you could share the code that you are using here so we can see what is happening and try to replicate it.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 4, 2023, 10:54pm UTC](https://discuss.elastic.co/t/create-new-field-value-is-incorrect/326912/3 "2023-04-04T22:54:41Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.