4 of 4 people found this helpful
I am attaching a twbx file.
Though what i have done is converting decimal of 10.9 to 10:54
Explanation :- 10 is exactly 10 hr. and for decimal meant .9 of 60 minutes ie. 54 minutes.
If this works for you, Please check this twbx file.
Thanks for the prompt reply. Unfortunately this doesn't work for me as my calculated field is a number(decimal), not a string.
I can't convert this to a string, as a calculation to get this decimal is needed.
2 of 2 people found this helpful
You can keep it as numeric values and inside calculation field, convert it into string using STR string function.
Then it will sort out that problem.
Please let me know, if this helps you.
Glad it helped you!