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)
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.
I read everywhere it should be in seconds not milliseconds.Thanks a lot!
It looks like you're new here. Sign in or register to get started.
