Index Sumproduct on date from date time

[SimChengKeng]

Hi,

I am trying to work on a overtime record whereby the overtime hours render on report the based on the month selected. However, my index sumproduct formula doesnt seen to execute as expected as my data were recorded in datetime format instead date. How to get the data in date instead datetime

=INDEX(Table2[[OT Hours]:[OT Hours]],SUMPRODUCT(--(Table2[[Name]:[Name]]=$B8),--(Table2[[Time In]:[Time In]]<=E$7),--(Table2[[Time In]:[Time In]]>=E$7),ROW(Table2[[OT Hours]:[OT Hours]]))-ROW(Table2[#Headers]))

Your assistance is greatly appreciated. Attached is my workbook on the overtime record

Thanks and Best Regards,
Kenneth

[Bo_Ry]

Please try INT

=SUMPRODUCT(INDEX(Table2,,9),--($B8=INDEX(Table2,,1)),--(E7=INT(INDEX(Table2,,4))))

[SimChengKeng]

Wow, ya, it worked prefect with INT , Thanks so much