Sum time from Time card

[Anonymous]

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	01/02/2020	11:49:00
1	Sarah	01/02/2020	13:05:00
1	Sarah	01/02/2020	17:25:00
3	John	01/02/2020	08:01:00
3	John	01/02/2020	11:49:00
3	John	01/02/2020	13:05:00
3	John	01/02/2020	17:25:00
3	John	01/02/2020	18:30:00
3	John	01/02/2020	19:25:00
4	Lucca	01/02/2020	08:05:00
5	Peter	01/02/2020	08:10:00
5	Peter	01/02/2020	12:10:00
5	Peter	01/02/2020	13:09:00

Times:

Sarah: 

08:08:00

John: 

09:03:00

Lucca:

-08:00:00

Peter:

-04:05:00

Table :

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("hdAxCoAwDAXQu3QWTNKKmiOIg+AoDkUEJwXR+xsp6mKbKXx4hJ8Mg0GTmd7vfpEJmAPlBAR3qBjQjFmCILKrFWIZCoWUTIFYSc22rPEqMfE1iYq3SFSoPbBiC2lRPzucpPacJv93TCCFpG4+5v2HIKQJkk7kYvnJeAE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Index = _t, Name = _t, #"Day DD-MM-YYYY" = _t, Check = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Day DD-MM-YYYY", type date}, {"Check", type time}, {"Index", Int64.Type}})
in
    #"Changed Type"

 Tks for your help...

[v-easonf-msft]

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]

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]

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