Skip to main content

    Power BI

    Needs Votes

    format hour 37:30:55 from excel

    Vote (10) Share
    ryo's profile image

    ryo on 07 Dec 2016 08:43:55

    hi,
    i want a format hour same native excel format hour 37:30:55 ([h]:mm:ss;@)
    example if I want the number of hours = 256:30:45
    (256 hours and 30 minutes and 45 seconds)
    I can't that i powerbi

    Comments (2)
    ryo's profile image Profile Picture

    Kevin Quintero on 05 Jul 2020 23:26:20

    RE: format hour 37:30:55 from excel

    Tiempo en formato(37:30:55) =
    VAR SEGUNDOSDASHBOARD=[Tiempo en minutos]*60
    VAR H=SEGUNDOSDASHBOARD/(60*60)
    VAR S1=INT(H)*60*60
    VAR S=SEGUNDOSDASHBOARD-S1
    VAR M =S/60
    VAR S2=S-(M*60)
    RETURN

    CONCATENATE(INT(H)&":"&M&":";S2)

    ryo's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:18:24

    RE: format hour 37:30:55 from excel

    We need it!