Convert seconds into hour minute and seconds

Question

Hello everyone!!I'm working with time values and I'm trying to get hh:mm:ss from an INT column.My dax measure is:TTime = VAR TotalSeconds = MIN( 'UserActivity'[Audio Duration In Seconds])VAR Days = INT(TotalSeconds / 86400)VAR RemainingSeconds = MOD(TotalSeconds, 86400)VAR Hours = INT(RemainingSeconds / 3600)VAR Minutes = INT(MOD(RemainingSeconds, 3600) / 60)VAR Seconds = MOD(MOD(RemainingSeconds, 3600), 60)RETURN&nbsp; &nbsp; TIME(Days * 24 + Hours, Minutes, Seconds)For example, 140771 seconds is 1 day 15 hours, 6 minutes and 11 seconds and it's showing 15:06:11 (measure formated as long time) and of course it should show 39:06:11Can anyone help me? What am I missing here?Thanks in advance

greg_deckler · Accepted Answer

pedroccamaraDBI&nbsp;Chelsie Eiden's Duration - Microsoft Fabric Community

Forum Discussion

Convert seconds into hour minute and seconds

2 Replies

Related content

Convert Seconds to DD:HH:MM:SS

Convert Days, Hours, Minutes and seconds in to Seconds

How to convert seconds to hh:mm:ss

How to convert seconds to hh:mm:ss

Convert HH:MM:SS to seconds