Forum Discussion

AbdulazizSIO's avatar
AbdulazizSIO
New Member
3 years ago

Dealing with long operation hours

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?

 

  

Need Help

2 Replies

  • JadhavVarsha_13's avatar
    JadhavVarsha_13
    Icon for Helper V rankHelper V
    3 years ago

    You can write a measure for average time:

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

     

  • AbdulazizSIO's avatar
    AbdulazizSIO
    New Member
    3 years ago

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