Path's Time to Next Step - in seconds

Hi Everyone,

I'm looking to understand the distribution of how long it takes users to move from one page view to the next page view. With a Path report, I can set this up and export the csv with Time to Next Step. However, in excel the Time to Next Step is a text string of either XXm XXs, XXs, or XXms. Does anyone have a ready to use excel formula I can use to convert this field to all seconds (or ms), so that I can create a chart that illustrates the distribution of time to next step using all the same unit of time measurement? 





1 comment
  • Rachel Lu

    This must be a specific setting on your device as I'm not able to recreate. Try this article from Microsoft to convert cells to different formats. I hope this helps!


Please sign in to leave a comment.

Didn't find what you were looking for?

New post