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; } } }

Calculate the difference between two date/time fields in a numeric field

Trevor Overstreet

Hey Community!

I am attempting to calculate the difference between a date/time field and display how long it took in time (numeric field <- if this is the correct field type for the formula).

Example:

Field: "Incident Detect time" is 6/26/23 6:34:00 AM

Field: "Start time" is 6/26/2023 5:23 AM

Current formula in automation:

But when using this formula it calculated 0, when I need it to be 6:34:00 AM - 5:23 AM = 1.11.

Should .days in the formula be something else?

Screenshot 2024-02-01 at 6.26.34 PM.png

Accepted answers

Mayuresh Kamble

Hi @Trevor Overstreet ,

Create MTTD field as a text type and then use the smart value in the automation - {{issue.customfield_13159.diff(issue.customfield_13462).days}} or {{issue.customfield_13159.diff(issue.customfield_13462).prettyPrint}}