function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
WTKWTK 

Case Duration field in "minutes"

I am trying to create a custom "One & Done" report to show cases that have been closed within 10 minutes of creation.
 
I created a custom field "Case Duration" which uses the formula "DateClosed - DateCreate" .
 
The problem is I don't know what the formula's output is as it "deducts days-hours-minutes" from "days-hours-minutes".
 
I'd like it to return a value in minutes only.
 
Anyone know how to accomplish this ?
 
 
Chris_627Chris_627
"DateClosed - DateCreate" will return the Case Age in Days (e.g. a return of value of 1.25 is 1 Day and 6 Hours). To show Age in minutes, use (DateClosed - DateCreate)*1440 --- where 1440 is the number of minutes in a day.