Jira Structures - custom field (number) can not be formatted to duration

[Daniel Schilling]

On a newly created structure, I need to add a time range.
I created a dedicated new custom field (number type).

No I am not able to format it to duration (not with a formula nor with the built in settings)

[Bert Dombrecht · Accepted solution]

Hello @Daniel Schilling ,

You should be able to set the output format of your formula to Duration:

You can also experiment with the Duration style setting.
"Basic" will count 24h as 1d, "Work Time" will count 8h as 1d, ...

If you are 'feeding' the formula a number (coming from your custom field), you need to translate it into milliseconds in your formula (1 hour = 3600000 milliseconds).

I hope this helps.

[Daniel Schilling]

I read everywhere it should be in seconds not milliseconds.
Thanks a lot!