Calculate Case Age in Salesforce Case Object Reports with a Custom Formula Field

Calculate how much time has elapsed from Case creation to present

• Days - NOW()-CreatedDate 
• Hours - (NOW() -CreatedDate )*24
• Minutes - (NOW() -CreatedDate )*1440

Create a Custom Formula Field to return the Age in Days, Hours, or Minutes (Non-Rounded Up Values)

1. Create a new Custom Field with the "Formula" data type.

• In Salesforce Classic: Click Setup | Customize | Case | Fields | New | Data type Formula
• In Salesforce Lightning: Click Setup |  Object Manager tab | Case | Fields & Relationships | New | Formula

2. In "Field Label" enter Case Age in (Hours / Minutes / Days), select Number then click Next.

3. Select and enter the Formula options below (depending on your requirements):

• Case Age in Days - IF (IsClosed,ClosedDate - CreatedDate,NOW() - CreatedDate)
• Case Age in Hours - IF( IsClosed , (ClosedDate - CreatedDate) *24, (NOW() - CreatedDate ) *24)
• Case Age in Minutes - IF( IsClosed , (ClosedDate - CreatedDate) *1440, (NOW() - CreatedDate ) *1440)