Hello,

I am using these two formulas, and I have having an issue with returning date/time for the last second of the hour.

For example if the time is 12:59:59, it's ignoring it. If I manually change the time to 12:59:58 it returns the data.

I am not sure why, as <=B40 time is 12:59:59 for this example.

I can create a sample sheet if it is helpful.

=SUMPRODUCT(--((WEEKDAY(Table1[Unit Date])=INDEX(SEQUENCE(7),MATCH($A$38,{"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"},0)))*((MOD(Table1[Unit Date],1)>=$A40)*((MOD(Table1[Unit Date],1)<=$B40)*(Table1[Unit Date]>0)*(Table1[Transaction Type])=5)*(Table1[Status]="Completed"))))

=IFERROR(SUM(IF(WEEKDAY(Table1[Unit Date])=INDEX(SEQUENCE(7),MATCH($A$38,{"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"},0)),IF(MOD(Table1[Unit Date],1)>=$A40,IF(MOD(Table1[Unit Date],1)<=$B40,IF(Table1[Transaction Type]=5,IF(Table1[Status]="Completed",Table1[Requested / Deposited Amount])))))),0)

Thanks for any help,
Nick