I want to create TAT for case object. i need a first response time of the case and i want to set this at 10 mins.. i have created time out and time in fields and applied formula for it and first response field where i have used (floor((NOW()- CreatedDate )*24)) + (((((NOW()- CreatedDate )*24)-floor((NOW()- CreatedDate )*24))*60)/100) formula.. and i have also created field named TAT and used formula 9 - First_Response_Time__c.
on record page i have added Business hours countdown timer but cant get proper TAT there.. can anyone help me with this?
FLOOR((NOW() - CreatedDate) * 1440) +
(((((NOW() - CreatedDate) * 1440) - FLOOR((NOW() - CreatedDate) * 1440)) * 60) / 100)
This formula calculates the first response time of the case in minutes by subtracting the case's CreatedDate from the current time, converting the result to minutes, and rounding down to the nearest integer.
10 - First_Response_Time__c
