i have used the function calworkdays to obtain the number of working days and i

Hi Nimisha,

If you are using Appian 7.2 and above,please take a look at the previous post forum.appian.com/.../e-99262

Otherwise you can try this expression,

=index(split((ri!date2-ri!date1),":"),1)&" Days "&index(split((ri!date2-ri!date1),":"),3)&" Hours "&index(split((ri!date2-ri!date1),":"),4)&" Minutes"

Hope this helps!

thanks for your response. we understand the aboove expression will display the difference between 2 date & time in Days / Hours / Mins format ..

However, we want to display the net working time between 2 date and time variables. So we can use either calworkdays() or calworkhours(). e.g. calworkhours(date1, date2, "Calendar")

But both these funtions returns numeric output. is there a better way to display the Numeric output into Days / Hours / Mins format ?