Translate Time in Status to only report Days

Megan_dbib63

Hello - 

 

I am using the Time in Status calculated column within structure. Instead of reporting weeks, days, minutes, and seconds or only hours - I would like it to report whole days. 

 

For example 1w 5h would become 6d or 8d (depending on whether we're talking about jira work days or total days). 

 

Is this possible via formulas? I am having trouble reading through the documentation to see if it is possible to rework the output in this way. Thanks! 

 

Stepan Kholodov

Hello @Megan 

You can do it by referencing the Tim in Status column in the formula like this:
ROUND(CALENDAR_DAYS(Time_in_status))

You would need to click on the Time_in_status variable on the list underneath the formula itself and select the Time in Status column on the list.

I hope this helps. If you need further assistance or help with anything else, please reach out to us directly at our support portal and we'll get back to you shortly.

Best regards,
Stepan
Tempo (the Structure app vendor)