Jira Automation Produces Inconsistent Decimal Hours from Time Fields

Question

Hi everyone,

I'm building a Jira Automation rule to calculate employees' worked hours from custom Start Time and End Time fields.

The automation works for most records, but I've noticed that some values are rounded differently when converting HH:MM into decimal hours. This becomes a problem because the calculated value is later exported to payroll reports.

For comparison, I tested the same inputs on https://mauricettecalcul.fr/, and the decimal hour values don't always match the results produced by Jira Automation.

The rule currently uses smart values and a custom number field to store the calculated result.

Has anyone found a reliable approach for handling time-to-decimal conversions in Jira Automation without introducing rounding inconsistencies? Would using ScriptRunner or another app provide more consistent results?

Thanks in advance for any suggestions.

Dan Breyen · Answer

Hi @Ethann Collins I found a similar issue on Atlassian's Jira Site.  AUTO-1862

AUTO-1674 - This one suggests doing math functions differently.

I also found a similar issue where the calculations are incorrect: AUTO-1681

In my opinion if you can reproduce the issue that the math is wrong, I would have your admin contact Atlassian Support for review.

I wouldn't expect to see rounding errors in the application.

Hope that helps.

Marc -Devoteam- · Answer

HI @Ethann Collins

Whenever you ask for help with an Automation Rule it will help us to help you if you provide:

1. what type of project is this (e.g., company-managed, team-managed, etc.),

2. images that show your complete rule.

3. images showing the details of any relevant actions/conditions/branches.

4. images showing the Audit Log details for the rule execution.

5. Explain where the issue is.

These questions are not for not willing to help, but to have community members understand on how your automation works.