How can you change seconds to hours/minutes in Adobe Analytics? | Community
Skip to main content
J
jeremyl39845142
September 26, 2017
Solved

How can you change seconds to hours/minutes in Adobe Analytics?

  • September 26, 2017
  • 4 replies
  • 3449 views

Hi,

Is there anyway to change the Adobe Analytics so that the reports show minutes/hours instead of seconds?

Many thanks,

jeremy

    Best answer by Gigazelle

    Thank you for the correction Chris, but actually now that I'm revisiting this, I don't think a static multiplier needs to be added at all.

    Creating a calculated metric that simply takes the time in seconds and converts it into time format fully resolves and time interpretation issue - no raw seconds, and no decimal minutes:

    Source image file 8009 not available

    The calculated metric automatically converts the raw number of seconds into hours/minutes/seconds. No multiplication or division required. The trick is to make sure you're using the 'Time' format,

    4 replies

    Gigazelle
    Adobe Employee
    GigazelleAdobe Employee
    Adobe Employee
    September 26, 2017

    Hi Jeremy, which report are you referring to?


    If it's something like time spent reports, you can use calculated metrics to get what you're looking for. Basically create a new calculated metric that is [time in seconds] * 60.

      christine-b
      christine-b
      January 26, 2018

      Hello

      well [time in seconds] * 60 it not accurate. it should be time in seconds / 60 and event there the decimal is not correct as the report will show time as 1mn 75 seconds and not convert the time after the decimal in minutes.

      It would be nice if we could have a better view on this in HH:MM:SS

      even in the calculated metrics turning the value in time rounds up or down to minute.

      and there can be a huge difference when the time is rounded iup

      eg

      1m01s is rounded to 1mn

      1m31s is rounded to 2mn

      for sites with few seconds spent on site it is a huge difference.

      Thanks

      Chris

        Gigazelle
        Adobe Employee
        GigazelleAdobe EmployeeAccepted solution
        Adobe Employee
        January 26, 2018

        Thank you for the correction Chris, but actually now that I'm revisiting this, I don't think a static multiplier needs to be added at all.

        Creating a calculated metric that simply takes the time in seconds and converts it into time format fully resolves and time interpretation issue - no raw seconds, and no decimal minutes:

        Source image file 8009 not available

        The calculated metric automatically converts the raw number of seconds into hours/minutes/seconds. No multiplication or division required. The trick is to make sure you're using the 'Time' format,

          L
          LukasJA2
          February 12, 2025

          Thank you for your response, it's interesting.

          In my case, I would like to go even further. I want to be able to see the time spent per month on a specific page. However, there is a lot of traffic, and with your method, I get a format like "15,005H, 25M, 23S," which isn't quite intuitive in my case. Is it possible to convert this into a format like "625D, 5H, 25M, 23S"?

           

          Thank you very much.

          christine-b
          christine-b
          January 28, 2018

          Hi Gigazelle

          Of course now looking at it, calculation is not needed.

          It's working wonders! and now my report just looks perfect.

          Thanks a lot for looking into it

          Terms & ConditionsAccessibility statement

          Loading footer...