calculate average time from string type

[Ruchita]

Hello!

I have a dataset with certain time of completion. They were originally ij long/big int format, and dusing formatDuration() in incorta, i have transformed it to (days, hours:minutes:seconds) format. This conversion of format results in an output in the string datatype. 

How can i construct a formula in incorta to get the average completion time in (days, hours:minutes:seconds) format ?

Example:

Task	Time Spent	Formatted Time Spent
1	4009573	01:06:49
2	5630253	01:33:50
3	10,103,173	02:48:23
average:-	6580999.67	01:49:41

Thanks in advance

[anurag · Accepted solution]

This video may give you some idea to solve this problem:

- https://www.youtube.com/watch?v=E0HPEiRQyjc

[marcpaige]

@anurag I liked the technique in the video. I put a comment on it. There is a limit to int() for conversion. I ran into this with very large millisecond counts. I was successful in using long() for the conversion with formatDuration().