Duration Mins in HH:MM format

[kumsha1]

Hi,

I have Duration (mins) changed to HH:MM format using below calc. measure (format-Text). But the same is displaying unwanted dimension values in a table and " : " is not being filtered. Can someone please help with this?, TIA, cheers !

Operating Duration (HH:MM) - ALL =

var vminutes = [Operating Duration (mins) - ALL]

var vhours = int(vminutes/60)

var vremainingminutes = MOD(vminutes,60)

return

FORMAT(vhours,"0#") &" : "&FORMAT(vremainingminutes,"0#")

---

 

[tex628 · Accepted solution]

Try this,

Operating Duration (HH:MM) - ALL = 
var vminutes = [Operating Duration (mins) - ALL]
var vhours = int(vminutes/60)
var vremainingminutes = MOD(vminutes,60)
return
IF(ISBLANK([Operating Duration (mins) - ALL]) , BLANK() , 
FORMAT(vhours,"0#") &" : "&FORMAT(vremainingminutes,"0#")
)

Br
J

[kumsha1]

@tex628 , many thanks for your help !