I am trying to find the average time elapsed (duration) between different stages in a sign-up process. Every stage is formatted as 3/14/2001 1:30:55 PM (G). I managed to get the duration between each stage as a calculated column as total seconds. I formatted it using the below:
It displays as DD:HH:MM:SS. The issue is that this outputs it as Text, and changing it to any other data type will not work. There are 5 stages, so 4 columns for time elapsed. How do i go about finding an total average time elapsed (or any other calculation) and have it displayed in an appropriate way?