Hi everybody,
i have an problem that´s driving me crazy! Hopefully somebody can help me.
I have a column with minutes, e.g. 200=200mins.
1.Goal:
I want to chance it into hh:mm:ss. To get it, I changed my MIN-Column into seconds.
-> MIN-Column * 60
Afterwards I converted my SEC-Column into hh:mm:ss with :
->
Zeit =
VAR Dauer = 'Tab_Kapapzitäten_Soll_IST_Werte'[Laufzeit in SEK]
VAR STD = INT(Dauer/3600)
VAR MINS =INT(MOD(Dauer-(STD*3600),3600)/60)
VAR SEK =ROUNDUP(MOD(MOD(Dauer-(STD*3600),3600),60),0)
VAR H =IF(LEN(STD)=1,
CONCATENATE("0",STD),
CONCATENATE("",STD)
)
VAR M =IF(LEN(MINS)=1,
CONCATENATE("0",MINS),
CONCATENATE("",MINS)
)
VAR S =IF(LEN(SEK)=1,
CONCATENATE("0",SEK),
CONCATENATE("",SEK)
)
RETURN
CONCATENATE(H,CONCATENATE(":",CONCATENATE(M,CONCATENATE(":",S)))
)
Another way to reach my goal was to convert MIN-Column into hh:mm:ss with :
Column:
Umrechnung Bearbeitungszeit/Auftrag = FORMAT('Tab_Kapapzitäten_Soll_IST_Werte'[Laufzeit in MIN]/60/24,"HH:MM:SS")
Both ways works, but I don´t get the final result I need.
Both values shows the duration for an order.
E.g.:
| Order No. | Sum of Zeit (Time) | Sum of Umrechnung Bearbeitungszeit/Auftrag (Conversion processing time/order) |
| F190103 | 21:57:33 | 21:57:33 |
| F190879 | 9:34:42 | 9:34:42 |
I need the sum of the column. the right result would be 31:32:15 , I get 7:32:15.
Does anybody has an idea how solve my issue?
Thanky you very much!!!!!!!!!!!!!!!!!!!!!!!
have a good day
cfreiburg
