Hours not matching with match function

[juanbolas]

Hello everyone,

I've made this Pommodoro sheet to order my tasks. Problem is, that the match function doesn't match hour of the task start between the top and bottom sections. The values are the same for the first four digit and a comparison results in TRUE.

Snippet below...

Please help!

Thanks in advance

Pommodoro 20220116.xlsm
	B	C	D	E	F	G	H	I	J	K	L
3					Day starts	7:00
4
5			Tasks	Length	Start	End
6	Top 3	1	BPS & DGI	0:30	7:00	7:30
7		2	CV	1:30	7:30	9:00
8		3	LDP 1	1:00	9:00	10:00
9	Top 5	4	Auto	0:30	10:00	10:30
10		5	LDP 2	2:00	10:30	12:30
11	Unplanned	6	Lunch	0:30	12:30	13:00
12		7	LPD 3	2:00	13:00	15:00
13		8	LDP Napoli (Virtual)	1:30	15:00	16:30			15:00	0,625000
14		9	H-Tools	1:00	16:30	17:30
15		10	LDP 4	2:00	17:30	19:30
16
17	Slot	Time	Task	Interruptions	Length	Task #
18	1	7:00	BPS & DGI			1
19	2	7:30	CV			2
20	3	8:00				2
21	4	8:30				2
22	5	9:00	LDP 1			3
23	6	9:30				3
24	7	10:00	Auto			4
25	8	10:30	LDP 2			5
26	9	11:00				5
27	10	11:30				5
28	11	12:00				5
29	12	12:30	Lunch			6
30	13	13:00	LPD 3			7
31	14	13:30				7
32	15	14:00				7
33	16	14:30				7
34	17	15:00	LDP Napoli (Virtual)			8			15:00	0,625000	TRUE
35	18	15:30				8
36	19	16:00				8
37	20	16:30	H-Tools			9			16:30	0,687500	TRUE
38	21	17:00				9
39	22	17:30				9			17:30	0,729167	FALSE
40	23	18:00				9
41	24	18:30				9
42	25	19:00				9
43	26	19:30				9
Dayplan

Cell Formulas
Range	Formula
F6	F6	=DayStartTime+"0:00:00"
G6:G15	G6	=F6+E6
F7:F12	F7	=IF(E7="",0,F6+E6)+"0:00:00"
F13:F15	F13	=ROUND(IF(E13="",0,F12+E12)+"0:00:00",4)
J13	J13	=F13
K13	K13	=F13
C6:C15	C6	=ROW()-ROW($C$6)+1
B18:B43	B18	=ROW()-ROW($B$18)+1
C18:C43	C18	=G$3+(B18-1)*"0:30"
D18:D43	D18	=IF(OR(G18="",G18=G17),"",OFFSET($D$5,$G18,0))
J34,J39,J37	J34	=C34
K34,K39,K37	K34	=C34
L34	L34	=K34=K13
L37	L37	=K37=F14
L39	L39	=K39=F15
G18	G18	=IF(MAX($G$5:$G$16)<$C18,"",IF(ISNA(MATCH(C18,F$5:F$16,TRUE)),G17,MATCH(C18,F$5:F$16,FALSE)-1))
G19:G43	G19	=IF(MAX($G$5:$G$16)<$C19,"",IF(ISNA(MATCH(C19,F$5:F$16,FALSE)),G18,MATCH(C19,F$5:F$16,FALSE)-1))

Named Ranges
Name	Refers To	Cells
Day_starts	=Dayplan!$G$3	F6, C18:C43
DayStartTime	=Dayplan!$G$3	F6, C18:C43

Cells with Data Validation
Cell	Allow	Criteria
D6:D10	List	=TaskInventory

 

[eastrand]

I'm not positive I'm seeing the issue. If you're talking about cell L39 with the false, it's a rounding issue. If you wrap it in a round function to four places, you'll get a true statement. You often have to round time when matching or comparing two times.

 

[juanbolas]

I'm not positive I'm seeing the issue. If you're talking about cell L39 with the false, it's a rounding issue. If you wrap it in a round function to four places, you'll get a true statement. You often have to round time when matching or comparing two times.

Eastrand, thanks. The solution works partially. Some cells will work I wrap, others won't. Any ideas? Thanks