2 Replies Latest reply on Feb 4, 2014 11:27 AM by Maksym Pryshchepa

    showing data in format hh:mm:ss

    Maksym Pryshchepa

      In the Exell file I have data "Time transaction" in format (02/01/1900  4:09:35).

      I need showing these data in format (hh:mm:ss).

      Example:  02/01/1900  4:09:35 = 52:09:35

      YearCountryTime transaction
      2013PL52:09:35
      2013PL32:09:35

      I will do operations with these data(Sum, Average, ...)

        • 1. Re: showing data in format hh:mm:ss
          Giacomo Vannucchi

          Hi Maskym,

           

          maybe you could try to create a new calculated dimension and get only the last 8 characters?

          Otherwise have you tried to select the Time transaction dimension, right click, and specify that is a date dimension? This way you will automatically have different level of date/time aggregation.

           

          Hope it will help you

           

          Cheers

           

          Giacomo

          • 2. Re: showing data in format hh:mm:ss
            Maksym Pryshchepa

            If I create new calculated dimension and get only the last 8 characters then will be 02/01/1900  4:09:35 = 4:09:35, I need have 52:09:35.

            If I specify that is a date dimension, will be

            Year             Country              Hour of Time transaction         Minute of Time transaction     Second of Time transaction

            2013             PL                                       4                                                 09                                                    35



            I need

            Year             Country             Time transaction

            2013             PL                            52:09:35