Problem: I am trying to figure out the time in hours it takes for a Lead to be contacted after the Lead record is created
1- Created a custom read-only Date/Time field called First_Contacted_Date__c
2- Built a Flow that sets the First_Contacted_Date__c to the date/time the first Task is completed
Where I Am Stuck:
The final part I need to solve is to create a number formula field on the Lead that calculates the number of hours between the 2 Date/Time fields First_Contacted_Date__c and CreatedDate.
Does not need to be business hours, just the total hours. I have found ways to create a text field that calculates number of business hours. But ideally, we need the number of hours as a number field.
Does anyone know if this is possible and how it can be done?
Thank you so much!