Problems with hours greater than 24 hours

[Anonymous]

Hello,

I am facing the problem of getting time over 24Hours in the measure field.

Actually I want the sum of time of different people working in 1 day (eg: 13:33:55 + 20:44:23 +15:31:11 + .......)

Thankx 

[Omega · Accepted solution]

You want to calculate how many hours each employee been working? 

[Omega · Accepted solution]

Create the below column: 

Column = 24-HOUR(Table2[Hourss])

Then, create the below measure: 

Measure = CALCULATE(SUM(Table2[Column]),ALLEXCEPT(Table2,Table2[Employee]))

[Anonymous · Accepted solution]

DAX Mode ( In this mode you can agregate for any dimension)

QtSegundos = SUM([Seconds])

Time=
VAR Horas = INT([QtSegundos]/3600)
VAR Minutos = INT(([QtSegundos] - (Horas * 3600))/60)
VAR Segundos = MOD([QtSegundos];60)
RETURN
Horas&":"&FORMAT(Minutos;"00")&":"&FORMAT(Segundos;"00")

[Omega]

Can you share sample data? I don't think I answered your question 🙂

[Anonymous]

1st Nov    abc    12:32:44

2nd nov   abc      14:33:23

3rd Nov   abc      13:33:33

1st Nov    pqr      20:22:12

2nd nov   pqr      16:34;54

3rd Nov   pqr       15:46:33

1st Nov    mnb     20:52:19

2nd nov   mnb      18:34;58

3rd Nov   mnb     16:46:37

so now i want the sum of abc(1st, 2nd, 3rd Nov), pqr(1st, 2nd, 3rd Nov), mnb(1st, 2nd, 3rd Nov) resp.

ie: (12:32:44 + 14:33:23 + 13:33:33)  of abc of 1st, 2nd & 3rd Nov resp.

[Omega · Accepted solution]

Create the below column: 

Column = 24-HOUR(Table2[Hourss])

Then, create the below measure: 

Measure = CALCULATE(SUM(Table2[Column]),ALLEXCEPT(Table2,Table2[Employee]))

[Anonymous]

Sum Duration1 =

VAR TotalSeconds=SUMX('Working Hr & Productivity - Nov',HOUR('Working Hr & Productivity - Nov'[Total Worked (Rota)])*3600+MINUTE('Working Hr & Productivity - Nov'[Total Worked (Rota)])*60+SECOND('Working Hr & Productivity - Nov'[Total Worked (Rota)]))

VAR Days =TRUNC(TotalSeconds/3600/24)

VAR Hours = TRUNC((TotalSeconds-Days*3600*24)/3600)

VAR Mins =TRUNC(MOD(TotalSeconds,3600)/60)

VAR Secs = MOD(TotalSeconds,60)

return IF(DAYS=0,"",IF(DAYS>1 ,DAYS *24 + Hours,Days)&":"&IF(Mins<10,"0"&Mins,Mins)&":"&IF(Secs<10,"0"&Secs,Secs))

// this work

[Anonymous]

The time is diplaying 00:50:00 where the exact sum of the time is 168:50:00

[Anonymous]

Thanks.

But the entire field is coming to be 00:00:00

[Omega · Accepted solution]

You want to calculate how many hours each employee been working?