Calculate start time from end time with multiple times per day for each ID

[leapinlabs]

I have an excel spreadsheet that calculates time from the last clock out of each day and adjust the formula to look at specific ranges for each employee. What I would like to have is a formula that can determine total hours (start time from final time) for each date for each employee id. As you can see on the attached, it is not calculating correctly. Column K (Daily Time) is where I want to calculate each date for each employee, leaving blank anything that is not a final clockout. I cannot add in xl2BB so have just pasted what I have currently here.

ID

Clock In ID

Clock Out ID

In time

Out time

Hours

Daily Time

3039​

DSM

DSM

9/19/2024 7:50​

9/19/2024 8:33​

0.72​

=IF(INT(G2)=INT(H3)," ",H2-MIN(FILTER($G$2:$G$36,INT($G$2:$G$36)=INT(H2))))

3039​

StuNeuharth

StuNeuharth

9/19/2024 9:02​

9/19/2024 12:23​

3.35​

=IF(INT(G3)=INT(H4)," ",H3-MIN(FILTER($G$2:$G$36,INT($G$2:$G$36)=INT(H3))))

3039​

DSM

DSM

9/19/2024 12:33​

9/19/2024 15:22​

2.82​

=IF(INT(G4)=INT(H5)," ",H4-MIN(FILTER($G$2:$G$36,INT($G$2:$G$36)=INT(H4))))

3039​

DSM

DSM

9/20/2024 7:17​

9/20/2024 8:44​

1.45​

3039​

StuNeuharth

StuNeuharth

9/20/2024 9:12​

9/20/2024 11:45​

2.55​

3039​

DSM

DSM

9/20/2024 11:54​

9/20/2024 13:20​

1.43​

8:24​

3040​

Alberts

Alberts

9/19/2024 6:12​

9/19/2024 15:54​

9.70​

10:53​

3040​

Alberts

Alberts

9/20/2024 6:24​

9/20/2024 15:11​

8.78​

10:15​

3145​

GPS

GPS

9/19/2024 5:15​

9/19/2024 15:42​

10.45​

10:41​

3145​

GPS

GPS

9/20/2024 5:16​

9/20/2024 14:54​

9.63​

9:58​

3161​

Firesteel Finisher 1

Firesteel Finisher 1

9/19/2024 5:36​

9/19/2024 9:38​

4.03​

3161​

TCMGR

MediaPork

9/19/2024 10:02​

9/19/2024 15:24​

5.37​

10:23​

3161​

Firesteel Finisher 1

Firesteel Finisher 1

9/20/2024 4:56​

9/20/2024 8:55​

3.98​

3161​

MediaPork

MediaPork

9/20/2024 9:21​

9/20/2024 14:53​

5.53​

9:57​

3182​

BatesWean

BatesWean

9/19/2024 5:01​

9/19/2024 10:29​

5.47​

3182​

Viola

Viola

9/19/2024 11:27​

9/19/2024 13:58​

2.52​

8:57​

3182​

BatesWean

BatesWean

9/20/2024 8:03​

9/20/2024 12:41​

4.63​

3182​

Viola

Viola

9/20/2024 13:11​

9/20/2024 15:24​

2.22​

10:28​

 

[Fluff]

@leapinlabs in future please mark the post that contains the dolution, not your post saying it worked. I have changed it for you this time.