Dealing with long operation hours

[AbdulazizSIO]

Hi, 

I'm trying to deal with long pump operation hours.  please find the attached What is the right format that will help me to sum or get the average of these hours?

  

[AbdulazizSIO]

it will take the first two digits of the hours, and I need 4 digits.

[JadhavVarsha_13]

You can write a measure for average time:

avgTime = Format(AVERAGE(timeAvg[time]), "HH:MM: SS")