How to edit Time Field Format to (1 Hr 02 Min)

[Pavan Kumar]

Hello Team,

I am thinking to change my Time field format to show Hrs and Mins please help me.

currently my field is showing like 0.92 Hrs this is bit confusion to Client

[Trudy Claspill · Accepted solution]

Hello @Pavan Kumar 

Is this a custom field you added to the system or a built-in field?

If it is a custom field, what is the field type?

If it is a built-in field, which field is it specifically?

Can you provide a screen image of what you see?

[Pavan Kumar]

Hello Trudy,

Thanks for Responding!!

It is a custom field and Field Type is Number field. The concept is It is the field which shows Time spent on ticket until it is resolved, please see the screen shot for more clarity

[Trudy Claspill]

Thank you for that additional information.

Jira doesn't natively support duration/time as a custom field type.

If you want to be able to display something in the duration form of # days # hrs # mins you would have to create customization to build that value from the number that you are recording. To display that you would need to have a separate Text based field because you cannot add text like "days" into a Number custom field.

When considering how to do that calculation you would need to consider:

- How are you getting the numeric value? Is that being set when a workflow transition executes or is it set manually by a user?

- When would you want to implement the formatting/transformation? Each time the value in the number field changes? Once per day? Each time a user refreshes a screen that would display the value?

- Do you want to display calendar time or business time durations? i.e. Do you consider a "day" as 24 hours or the number of working hours?

- Do you want to consider non-working days and holidays as part of that duration?

The transformation could potentially be done within an Automation Rule if you are limited to only native functionality.

Are you open to acquiring a third party app? I know that there are apps that focus on "time in status" functionality which you might useful.

There might be other apps that would just give you additional types of custom fields that would make your process easier.

[Pavan Kumar]

Hello Trudy,

That's Awesome the way you put this question I can see your experience in above question!!
As per your suggestions above I want to create a Field which show Days, Hours, Min for working days when every time page refreshes Automatically no manual. so, you are telling it is possible with Automation? I don't prefer third party app

[Trudy Claspill]

Is the value in the Time in Status field always going to represent hours?

How many working hours do you have in a working day?

I believe it is possible to do this through an Automation Rule structured thus:

Trigger: Field value changed
- Field: Time in Status

<multiple steps here to convert the value to a text duration display>

Action: Edit Work Item
- Field to set: <your new text custom field for displaying the converted value>
- Value: <pulled from the steps in the middle that does the conversion>

I have not worked out the details of the steps in the middle. It would involve, I believe, multiple math operations to:
- convert the original value to a total number of minutes
- divide that new value by 60 to get the number of hours, with a remainder that is the left over minutes.
- divide the number of hours by the number of working hours in a working day to get the number of days, with a remainder that is the left over hours

[Pavan Kumar]

Much Appreciated Trudy This will very greatly help!!