Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sum time from Time card

Hi Folks, I`m trying to get all  employee worked time. E.g. In this table we have Sarah, John, Lucca and Peter. Index Name Day DD-MM-YYYY Check 1 Sarah 01/02/2020 08:01:00 1 Sarah...
Need Help
v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi , Anonymous 

Can you talk about how to calculate the working hours of workers?

I don't  quiet understand Lucca and peter's worked time.

Best Regards,
Eason

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-easonf-msft.

    It's because the schedule is 8 hours/day and 1 hours to lunch, so I wait for this hours.

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      6 years ago

      Hi ， Anonymous 

      Sorry for the later reply .

       

      It's still  difficult to understand   how to calculate the working hours .

      The most confusing thing is that the number of records for each person is completely different.

      Without a specific calculation rule, it would be difficult for me to write dax...

      Sarah : 
(11:49- 08:01)+(17:25 - 13:05)                    3:48+4:20=08:08    
the same to the result your gave  "08:08"

John:
(11:49:-08:01)+(17:25-13:05)+(19:25-18:30)        3:48+4:20+0:45=8:03    
How  to get  the result "09:03" ？

Lucca：  One record   "08:00"     
How  to get  the result "-08:00"?

Peter:   Three record
How  to calculate  the result "-04:05"?

       

      Best Regards,
      Community Support Team _ Eason