nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Automation - Convert number to time

Csaba Vertessy_voxr2o

Hello,

I'm looking for a solution to convert number to time (d/h/m/s)

I was following this article to calculate time spent in the pending status. The result is a numeric number.

Is there a way to get convert the result to d/h/m/s?

Thanks for any suggestion.

Accepted answers

Bill Sheboy

Hi @Csaba Vertessy

When using the diff() function on two date (or date / time) smart values, you may use the prettyPrint unit of measure to make that human-readable. For example:

{{issue.created.diff(now).prettyPrint}}

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-difference---

Kind regards,
Bill

All comments

Evgenii

Hi, @Csaba Vertessy

What is original value, that you try to convert to time?
Is it numeric field, ot time duration field, like logged time?

You can use smart value math functions, to convert number to date units. Here are some examples:

Seconds

{{timetracking.timeSpentSeconds}}

Minutes

{{#=}}{{timetracking.timeSpentSeconds}} / 60{{/}}

Hours

{{#=}}{{timetracking.timeSpentSeconds}} / 3600{{/}}

Days

{{#=}}{{timetracking.timeSpentSeconds}} / 3600 / 24{{/}}

Csaba Vertessy_voxr2o

Hi @Evgenii ,

The result is the diff between two transition dates.

For eg.; the result is 59,843 (in seconds).

I want to convert this to human readable value like: 0d 16h 37m ...s

Evgenii

Got it. Then you can use smart values like:

{{#=}}{{timetracking.timeSpentSeconds}} / 3600 / 24{{/}}d {{#=}}{{timetracking.timeSpentSeconds}} / 3600{{/}}h {{#=}}{{timetracking.timeSpentSeconds}} / 60{{/}}m {{timetracking.timeSpentSeconds}}s

Use your smart value instead of mine {{timetracking.timeSpentSeconds}}, which I showed for example

Bill Sheboy

Hi @Csaba Vertessy

When using the diff() function on two date (or date / time) smart values, you may use the prettyPrint unit of measure to make that human-readable. For example:

{{issue.created.diff(now).prettyPrint}}

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-difference---

Kind regards,
Bill

Csaba Vertessy_voxr2o

Hello Bill,

Thank you for your reply.

But I get this error:

Error rendering smart-values when executing this rule:
Too many numbers or variables:

For this:

{{#=}}{{NumberOfSeconds}} + {{IF(TotalPendingSeconds,TotalPendingSeconds,0)}}{{/}}

Bill Sheboy

The syntax of the if() expression you are trying is this:

{{if(someBooleanExpression, valueToReturnForTrue, valueToReturnForFalse)}}

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-conditional-logic/#if

But you appear to be passing a number for the Boolean expression.

If changing that does not help, please post an image of your complete rule, images of the relevant actions / conditions / branches, and of the audit log details showing the rule execution. Those will provide context for what you are observing. Thanks!

Csaba Vertessy_voxr2o

Hi @Evgenii ,

thanks for you suggestion, however, your dividing provides the same result for each math. So its not converting.

Thanks anyway, I appreciate it.

Csaba Vertessy_voxr2o

Hi @Bill Sheboy ,

I'm following this KB: How to use automation to get the time an issue was in a status | Jira | Atlassian Documentation

Under Saving Cumulative Time part, I'm using

{{#=}}{{NumberOfSeconds}} + {{IF(TotalPendingSeconds,TotalPendingSeconds,0)}}{{/}}

The result is in seconds. Far as I understood, prettyPrint does not work here in the expression (at leas it was empty for me).

Then I tried to create a variable, do the mat there and use Edit issue to update the field with the value and prettyPrint

If I remove prettyPrint from the math, it works:

Any thoughts?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

automation

time