Report on Case Aging - Using Custom Formula Field #inSalesforce

Create a Custom Formula field to calculate the Case Age.

Steps:

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

Create new custom field - formula data type 

Setup | Object Manager tab | Case | Fields & Relationships | New | Formula | Name the field may be Case Age in Days, Case Age in Hours, Case Age in Minutes | Return type as Number | Next

Based on need,

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)

Where :

how much time has elapsed from Case creation to present are like -

Days - NOW()-CreatedDate 

Hours - (NOW() -CreatedDate )*24

Minutes - (NOW() -CreatedDate )*1440

Once the above is done, create the report with filter or columns using the above mentioned fields.

Visual:

https://www.youtube.com/watch?v=-TGhVm_qedE

https://www.youtube.com/watch?v=3OhYhn_VPnI

Reference: https://help.salesforce.com/s/articleView?id=000341512&type=1