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

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

Hi,

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

Many thanks,

jeremy

    Gigazelle
    GigazelleAccepted solution
    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,

    View reply

    5 replies

    christine-b
    christine-b
    New Participant
    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

    Translate
    Gigazelle
    GigazelleAccepted solution
    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,

    Translate
      LukasJA2
      New Participant
      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.

      Translate
      christine-b
      christine-b
      New Participant
      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

      Translate
        Gigazelle
        Gigazelle
        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.

        Translate
          Terms & ConditionsAccessibility statement

          Loading footer...