Skip to main content
Topics#Customer ServiceBarry Edwards's Question
Barry Edwards (Embraer Executive Jets) asked in #Customer Service
Apr 12, 2012, 5:10 PM

Can I take the case open time and case closed time and calculate the minutes?

My company wants to build a field that will calculate the time it takes to close our cases.  It currently stamps Date/Time in the fields.  Is this a MID function that exist as two behind-the-scenes formula fields and calculate the time total in a third visible field?
1 answer
  1. Austin Nordman (Unemployed)
    Apr 12, 2012, 5:14 PM
    Hmmm ok your formula would look something like this:

     

    (((closetime - opentime) * 24*60) + ((Hours(closedtime) - Hours(opentime)) * 60) + (Minutes(closedtime) - MINUTES(opentime)))
Write an answer...
0/9000