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?
Thanks,
Rachel
1
Comments
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.