function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Anshuman ParhiAnshuman Parhi 

Calculate working hours of user/owner for perticular record.

Calculate working hours of  user/owner for perticular record.


How to create this.....any solution
ANUTEJANUTEJ (Salesforce Developers) 
Hi Anshuman,

>> https://developer.salesforce.com/forums/?id=906F0000000MLAoIAO

This link has a similar implementation as mentioned you can try checking the below answer:

Create a formula field with return type as text.
I am assuming each record during save will have values into all these fields, in that case the below formula should work.

((DATEVALUE(Evening_Sign_Off__c))-(DATEVALUE(Evening_Sign_Off__c))) + (DATEVALUE(Afternoon_Sign_Off__c)-(DATEVALUE(Morning_Sign_In__c)))

Let me know if it helps you and close your query by marking it as the best answer so that it can help others in the future.  

Thanks.
Anshuman ParhiAnshuman Parhi
This is not working....can u give a proper solution for this question.