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 ?
|Task||Time Spent||Formatted Time Spent|
Thanks in advance
Solved! Go to Solution.