2 Replies Latest reply on Dec 6, 2017 11:37 AM by Shinichiro Murakami

    creating the Time Range

    sudhakar reddy

      Hello All,

       

      I've a field showing the result as how much time it has taken to complete the task .

       

      O/P of the field :

       

      01 hrs 49 mins 57 sec
      01 hrs 51 mins 43 sec
      01 hrs 51 mins 48 sec
      01 hrs 51 mins 54 sec
      01 hrs 52 mins 07 sec
      01 hrs 52 mins 33 sec
      01 hrs 54 mins 20 sec
      01 hrs 58 mins 44 sec
      01 mins 08 sec
      01 mins 27 sec
      01 mins 41 sec
      01 mins 52 sec
      02 hrs 01 mins 30 sec
      02 hrs 01 mins 54 sec
      02 hrs 04 mins 47 sec
      02 hrs 25 mins 43 sec
      02 hrs 41 mins 19 sec
      02 hrs 42 mins 01 sec
      02 hrs 42 mins 38 sec
      02 hrs 46 mins 59 sec
      02 mins 41 sec

       

      I want to show the above field as a filter showing no of task completed in range of 1hr,2hr,3hr....

       

      Please help me out creating the calculated filed for above.

       

      Regards,

      Sudhakar Reddy