Change time format from hh:mm:s to hh:mm:ss

[Anonymous]

Hello,

I would like to change the time format from hh:mm:s to hh:mm:ss.

I used the following  measure:

PCR =

Var vSeconds = 'Medidas'[Average]

var vMinutes = int(vSeconds/60)

var vRemainingSeconds= int(MOD(vSeconds,60))

var vHours = INT(vMinutes/60)

var vRemainingMinutes=MOD(vMinutes,60)

return

vHours&

vRemainingMinutes&":"&

vRemainingSeconds

The output is: 

But I would like to see the 0 before the number when the seconds don't reach 10. Something like this:

03:14

03:16

03:04

03:08

What measure should I use to get it?

Thanks in advance for your help!

[Samarth_18 · Accepted solution]

HI @Anonymous ,

You can update your code like this:-

PCR =
VAR vSeconds = 'Medidas'[Average]
VAR vMinutes =
    INT ( vSeconds / 60 )
VAR vRemainingSeconds =
    INT ( MOD ( vSeconds, 60 ) )
VAR vHours =
    INT ( vMinutes / 60 )
VAR vRemainingMinutes =
    MOD ( vMinutes, 60 )
RETURN
    vHours & vRemainingMinutes & ":"
        & IF ( vRemainingSeconds < 9, "0" & vRemainingSeconds, vRemainingSeconds )

Thanks,

Samarth

[Samarth_18 · Accepted solution]

HI @Anonymous ,

You can update your code like this:-

PCR =
VAR vSeconds = 'Medidas'[Average]
VAR vMinutes =
    INT ( vSeconds / 60 )
VAR vRemainingSeconds =
    INT ( MOD ( vSeconds, 60 ) )
VAR vHours =
    INT ( vMinutes / 60 )
VAR vRemainingMinutes =
    MOD ( vMinutes, 60 )
RETURN
    vHours & vRemainingMinutes & ":"
        & IF ( vRemainingSeconds < 9, "0" & vRemainingSeconds, vRemainingSeconds )

Thanks,

Samarth

[Anonymous · Accepted solution]

I  updated it and it's working

Thanks a lot !! @Samarth_18