Time

[MarcMa1]

Hello Reporting Community. I'm trying to capture the time that an issue or task goes into a specific status for the first time. The catch is these items do not follow a specific flow of status changes. These items start off in "New" then can move into other status, but looking for the time difference from the New to the first status change. My thought was to created a calculated field for each status to capture the time, but unsure how to write the formula for the subtraction. Any help would be great. Thank you, Marc Marc Mattaroccia Renown Health

[NRYNR]

Here's an article on how to capture the timestamp for each status. "https://support.workfront.com/hc/en-us/articles/360001028853-Understanding-Common-Uses-of-Text-Mode"> https://support.workfront.com/hc/en-us/articles/360001028853-Understanding-Common-Uses-of-Text-Mode Narayan Raum Senior System Admin, Solution Architect & Delivery Lead of Workfront. Service & Business Manager. COE Lead. AVP Enterprise Data Governance Execution (EDGE) SunTrust Bank

[MarcMa1]

Thank you Narayan, My real question is how to write the formula to do the subtraction between the original submission date and first state change. Thanks, Marc Marc Mattaroccia Renown Health