Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

How to calculate Decimal number to hours minutes seconds format

Hi everyone, 

Please could i get help to calculate decimal number to hh:mm:ss format. 

 

I've included sample data as well as the output required. 

Expected output

Screenshot 2021-11-22 173129.png

Calculated Datacard

Screenshot 2021-11-22 173044.png

Thanks

Vilas

Need Help

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Thanks Surya

it will working fine

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

@VILAS 
I am using measure to get the expected output
where table[TVT] is the column contains total view time in sec 

time =
var a = SUM('Table'[TVT])  // calculating total view time
var b = MOD(a,60)
var c = QUOTIENT(a,60)
return c & "m " & b & "s"

Surya9_0-1637585614973.png

 

Anonymous
Not applicable

Thanks Surya

it will working fine

Anonymous
Not applicable

@Anonymous Please mark this as a solution

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.