Skip to Content
0
Jan 13 at 01:50 PM

Time Calculations

224 Views Last edit Jan 13 at 03:47 PM 2 rev

Hi All,

I have a similar data in my report.

image.png

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

Attachments

image.png (18.5 kB)