Show elapsed time in hours at Project and Task level

Hi Team,

Here is the summary of client requirement.

• Add a field at task and project and Parent task field  
• Use Actual Start and Actual End Dates
• If either are blank the result should be blank

We encountered the following constraints:

• The Actual Start Date and Actual End Date fields are currently of the “Date” type. To calculate the time between two dates, we would need to change the field type to “Date and Time.”
• We can’t account for known holidays.
• We need to figure out how to calculate working hours if employees work in different shifts.

Could you please provide guidance on how to implement the calculation of elapsed time in the project and task records?