Time in status format

[Carla Bismuth]

I find the field "time in status" that I decide to use in order to monitor the time of ticket on specific status, it's appearing like the following how do I know the format and can I change it. 

0.001 ; 116.335

[Nic Brough -Adaptavist-]

The usual "time in status" field is not intended to be a field you directly see the raw data of.  It's calculated internally and stored so that the "time in status" reports don't have to do all the calculations every time they are run.

This might not be your time in status field, but it does look like it.

[Alexander Bondarev]

Hi, @Carla Bismuth !

It depends on your field and how exactly it is calculated, go to Administration > Issues, and select Custom fields.

Find the field "time in status" - we interested in field's type. We do this in order to understand which plugin is used to make it work.

[Carla Bismuth]

Hello, thanks for answering, when I get to administration it display project and only one that is not mine. When I'm doing the search I'm still not able to reach my project what I should do ? 

[Carla Bismuth]

Hello, when I get to custom field it brings me here what I should do to make it display as hours or days 

[Mohamed Benziane]

Hi,

This field come from a plugin ? If so can you tell us which one ?

[Carla Bismuth]

Hello, the field is not coming from a plugin it's in the column option 

[Nic Brough -Adaptavist-]

Mohamed is asking what code is providing the "time in status" field. 

You can check that by going to Admin -> Issues -> Custom fields and finding the field.  Look beneath its name to see "field type".  Most will name the app (plugin) that provides the field.  If it just says "time in status", then I'd guess it's probably the one from the standard Atlassian time in status report, which does not hold human-readable data in the field.

[Carla Bismuth]

here is the code do you know how I should set it up to see number of days please ? 

[Nic Brough -Adaptavist-]

Ah, ok, it's not a time-in-status field, it's a calculated field, based on functions that look at the actual time in status.

That's fine, but the trick is to understand that most computers work in "epoch time" - that is, a date/time is actually just a number of milliseconds elapsed since a base date.  And for consistency, most represent lengths of time in a number of milliseconds.

For an hour, you would find 3,600,000 in the database.

Your expression is reading three durations out, and dividing them by 1000 to get seconds, 60 for minutes, then 60 for hours.

So to get days, add a *24 to all three formulae.

[Carla Bismuth]

Hello, thanks I did the follow up as you advise here it is and the result is wrong, below the formula 

[Carla Bismuth]

And here screenshot of the information, I check with person assigned to the ticket for just few estimation seems to be okay and for others it is not at all. 

What I can do to know from where the issue is coming please ? 

[Nic Brough -Adaptavist-]

You need to add the *24 to each of the three calculations on the fields, not the overall result.