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 

try below measure. It might help

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
 
 
 
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
  • RussHaight's avatar
    RussHaight
    New Member
    2 years ago

    Thank you for your reply. Copying and pasting what you wrote throws a lot of red so I changed it to what i think you are explaining to me but I get the following error. 

     

    Also, is this formula supposed to be a measure or an added column on the punch table? 

     

     

    • 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 ))

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    Hi, RussHaight 

     

    If above post helps, then please consider Accepting it as the solution to help the other members find it more quickly