Forum Discussion

RussHaight's avatar
RussHaight
New Member
2 years ago
Solved

Calculate Time

Hello, I'm trying to figure out a way to calculate time diff. In the table the time in and time out are in the same field with a punch type determining if it was in or out   Table structure is lik...
Need Help
  • RussHaight's avatar
    RussHaight
    2 years ago

    sorry-had an extra ], I removed it now I don't get the red )

    Thank you-I'm going to see if I can leverage a measure as to what I am trying to do-which is calculate hours workd by employee_number on any given day/week/month/etc

Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

hi, RussHaight 

it's a measure.

and remove   ))  from code  it give you answer

 

timediff =
var g =MIN('time'[punch date/time])
var a = CALCULATE(MAX('time'[punch date/time]),'time'[punch type]="id")
var b = CALCULATE(MAX('time'[punch date/time]),'time'[punch type]="od")
var c =CALCULATE(DATEDIFF(a,b,HOUR),'time'[punch date/time]=g)
return
c
 
in above code red part is table name i use as 'time' so replace your table name with 'time'
RussHaight's avatar
RussHaight
New Member
2 years ago

the red ) is added automatically when I click out of the code window and if I hit enter again while in the code window, it adds another one, and so on.

 

so after Return

c

I click out and it adds one ), I click in and then out, it adds another one ))

  • RussHaight's avatar
    RussHaight
    New Member
    2 years ago

    sorry-had an extra ], I removed it now I don't get the red )

    Thank you-I'm going to see if I can leverage a measure as to what I am trying to do-which is calculate hours workd by employee_number on any given day/week/month/etc