Seperate Working Hour for each people

[Xcelvba]

Hello, There i'm Thai person, First sorry for i'm not good at english.But I'm try to describe for my work and need to help

1. In Column A,B,C is general data. (A = Id , B = Date , C = Time )

2. Column D is Unique-iD find from Column A I got it

(=INDEX(A:A,AGGREGATE(15,6,ROW($A$2:$A$1384)/(MATCH($A$2:$A$1384,$A$2:$A$1384,0)=ROW($A$1:$A$1384)),ROWS(D$2:D2)))

3.I need formular for Column F to M by check data from Column D ( ID) prepare Column A (ID) and check the time in Column C then fill in Column F to M
Thank you in advance

[Bo_Ry]

11:59 AM => 11:59
12:00 PM => 12:00
11:59 PM => 23:59
12:00 AM => 0:00

there is no 18:00 PM there is only either 6:00 PM or 18:00 without PM

correct row 1 to 07:00-08:00 … 02:00-07:00

and try this in F2

=REPT("✓",COUNTIFS($A$2:$A$1384,$D2,$C$2:$C$1384,">="&LEFT(F$1,5),$C$2:$C$1384,"<"&RIGHT(F$1,5)+(LEFT(F$1,5)>RIGHT(F$1,5)))+(LEFT(F$1,5)>RIGHT(F$1,5))*COUNTIFS($A$2:$A$1384,$D2,$C$2:$C$1384,"<"&RIGHT(F$1,5)))

[MarvinP]

Hi Xcelvba,

See if a Pivot Table to the right of your data helps at all for an answer. I'm not exactly sure how you are checking your data.
Pivot for Xcelvba.xlsx

[AliGW]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...ch-people.html