Convert Seconds to Hours and Mins

[Khushidesai0109 · Accepted solution]

Hiii @SunnyDay85 

please use this measure to get seconds in hour and minutes

TotalHoursMinutesMeasure =
VAR TotalSeconds =
SUM ( 'Table'[Seconds] )
VAR TotalMinutes =
QUOTIENT ( TotalSeconds, 60 )
VAR RemainingSeconds =
MOD ( TotalSeconds, 60 )
VAR TotalHours =
QUOTIENT ( TotalMinutes, 60 )
VAR RemainingMinutes =
MOD ( TotalMinutes, 60 )
RETURN
FORMAT ( TotalHours, "00" ) & ":"
& FORMAT ( RemainingMinutes, "00" ) & ":"
& FORMAT ( RemainingSeconds, "00" )

If it helped you, then please consider Accepting it as the solution to help the other members find it more quickly and also give a thumbs-up

[Anonymous]

Excellent got this to work for me and was exactly why I registerd for an account here. Thank you

[Khushidesai0109]

Hiii @SunnyDay85 
Please see the updated measure and solution

[Anonymous]

Hi, @SunnyDay85 

You can try @Greg_Deckler way. Or you can refer to the following link.

Solved: Convert Seconds to Hours - Microsoft Fabric Community
Solved: Converting seconds into day hours min sec - Microsoft Fabric Community

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Greg_Deckler]

@SunnyDay85 Chelsie Eiden's Duration - Microsoft Fabric Community