How to shoe only 2 seconds instead of this number

[DylanPulido]

I have this formula, but the seconds in the table shows wrong, how can i modify the formula?

Tiempo Por Proceso = VAR allseconds =

banisipanama[AverageMeasure]

VAR days =

INT ( allseconds / 24 / 60 / 60 )

VAR hours =

MOD ( INT ( allseconds / 60 / 60 ); 24 )

VAR minutes =

MOD ( INT ( allseconds / 60 ); 60 )

VAR seconds =

MOD ( allseconds; 60 )

RETURN

days & "d: "

& hours

& "h: "

& minutes

& "m: "

& seconds

& "s"

[az38]

Hi @DylanPulido 

try to round your initial measure

Tiempo Por Proceso = VAR allseconds =
ROUND(banisipanama[AverageMeasure];0)
VAR days =
INT ( allseconds / 24 / 60 / 60 )
VAR hours =
MOD ( INT ( allseconds / 60 / 60 ); 24 )
VAR minutes =
MOD ( INT ( allseconds / 60 ); 60 )
VAR seconds =
MOD ( allseconds; 60 )
RETURN
days & "d: "
& hours
& "h: "
& minutes
& "m: "
& seconds
& "s"

[Greg_Deckler · Accepted solution]

Perhaps:

VAR days =

INT ( allseconds / 24 / 60 / 60 )

VAR hours =

MOD ( INT ( allseconds / 60 / 60 ); 24 )

VAR minutes =

MOD ( INT ( allseconds / 60 ); 60 )

VAR seconds =

MOD ( allseconds; 60 )

RETURN

days & "d: "

& hours

& "h: "

& minutes

& "m: "

& INT(seconds)

& "s"

[DylanPulido]

Thank you, it works