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!