Time Calculations

Hi All,

I have a similar data in my report.

Scenario:

1. Same Case having multiple Work Lines of different types Travel, Online Support, Repair

2. Need to calculate Total Travel Hours, Total Site Hours based of Start time and End Time.

3. For same Case if we have multiple Work Lines with same Owner Name then we have to calculate Total Hours based on calculated Total Travel Hours and Total Site Hours. (Highlighted in Blue)

4. For same Case if we have multiple Work Lines with different Owner Name then we have to calculate Total Hours based on calculated Total Travel Hours and Total Site Hours separately. (Highlighted in Yellow and Pink)

Can someone please help me with this? Is it possible to calculate this without Break?

Thanks in advance!

Regards,

Bhagya