function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Mikeb66Mikeb66 

Need formula for Hour Created & Hour Closed for a case

I want to be able to run a report based on the number of cases opened and closed per hour of the day, so I need to create a custom field that takes the Time/Date Opened field and converts it to just show the Hour created (24 hour time) and the same thing for the Time/Date Closed.

 

I've done this in the past at my last company, but don't  remember the formula. Does anyone know how to do this?

thecrmninjathecrmninja

The answer may be found here...

 

Calculating hour from CreatedDate

 

Please note, this solution does not take into account Daylight Savings