Forum Discussion

shannon8000's avatar
shannon8000
Frequent Visitor
2 years ago

PBI seconds conversion to hh:mm

Hello, I've tried two different formulas I've found in these forums.  At first it looks like it is working but then the math isn't mathing when reviewing the output. In the below example, you can s...
Tips and Tricks
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
2 years ago

Hi shannon8000 

Here is an example

and here is the formula

Total duration =
var _seconds = SUM(Sheet1[ACTVTY_TTL_SEC])
var _minutes = INT(_seconds / 60)
var _RemainingSeconds = MOD(_seconds, 60)
var _Hours = INT(_minutes / 60)
var _RemainingMinutes = MOD(_minutes, 60)
var _Days = INT(_Hours / 24)
var _RemainingHours = MOD(_Hours, 24)
return
_Days & " D : " &
_RemainingHours & " H : " &
_RemainingMinutes & " M : " &
_RemainingSeconds & " S  "
 
 
shannon8000's avatar
shannon8000
Frequent Visitor
2 years ago

Hi Amine!

 

I applied as recommended and the output was interesing.

 

I will poke around some more to see what is happening.

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    2 years ago

    You have a relationship problem in your Matrix or Table visual.