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
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
Icon for Community Support rankCommunity 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