One Suggestion, An Attached workbook would get you help faster.
Whatever the field you have 1.75*60
Right Click on the field in Measures --> Default Properties --> Number Format --> Custom --> hh:mm:ss
It will give the required O/P
Hope this helps
Kindly mark this answer as correct and helpful so that it will help others
Find my approach below,
First you needs to convert your avg. minutes to seconds. For that you can use below logic
Now create below calculated field to get the hh:mm:ss from the [Seconds] field
< 10 THEN "0" ELSE "" END + STR(INT(SUM([Seconds])%86400/3600))
+ ":" +
< 10 THEN "0" ELSE "" END + STR(INT(SUM([Seconds])%3600/60))
+ ":" +
IF INT(SUM([Seconds]) %3600 %60)
< 10 THEN "0" ELSE "" END + STR(INT(SUM([Seconds]) %3600 %60))
Let us know if this help.
Thanks for all of the replies! Naveen, I tried your method, while the formatting did change the o/p to the format I need the data was not correct. Mahfooj, I think that what I have been doing is pretty similar to your suggestion. My pain point occurs when I try to add the calculated field to the table. I think since it's formatted as a string, Tableau will not let me drop it in the Measure Values shelf. I'll attach a workbook like Deepak mentioned.
1 of 1 people found this helpful
//use a custom number format of 00:00:00 (drop the first 0 to get rid of leading 0's for hours)
IIF([IVR Seconds] % 60 == 60,0,[IVR Seconds] % 60)// seconds
+ IIF(INT([IVR Seconds]/60) %60 == 60, 0, INT([IVR Seconds]/60) %60) * 100 //minutes
+ INT([IVR Seconds]/3600) * 10000 //hours
Set the default format like this
Follow this wonderful blog post for more details regarding formatting time duration
Hope this help.