My data for a duration of talk time is in milliseconds and I need to represent it in a Hour:Minute:Seconds time format. At the moment I am using ([Yesterday's Talk Duration)]/(1000*60*60) but that gives me a number such as 1.93 hours. I would like to illustrate it as 1:55:23. I also need to do it in a calculated field.
You need to write a calculation which will take each part from 1.93 like Hours, then count the Minutes and also for Seconds.
'hours calculation'+':'+'minutes calculation'+':'+'seconds calculation'
And check it
Hope this will help)