I am working with a Formula column on my Structure board. In this Formula, I want to convert timeSpent into a number value, in weeks. Ultimately, the purpose is to then divide that value by another number that is already in weeks, then display the final Formula column as a Percentage.
I am struggling to get timeSpent converted to weeks correctly within my Formula.
Using Google time converter, 1669200000 milliseconds does not convert ~11 weeks.
However.. 1669200000 milliseconds does convert to ~2.7 weeks...
Any ideas on what formula Structure is using to get 1669200000 into ~11 weeks, similar to Duration "Work Time" ON, so that I can replicate it within my Formula column??
Here are some screenshots demonstrating...
I think I was able to convert my total milliseconds into workweeks by dividing it by the number of milliseconds in 40 hours. :)
It seems like the ~2.7 number is total time, whereas "Work Time" uses your Jira work settings. So I need a formula to convert total time into Jira weeks. (My settings are 5 days in a week, 8 hours in a day.)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.