Hello Tia, I simplify your example with translation time values to a decimal values (time 9.45 is decimal 9.75)

Run this script

Declare @Table table (Client_Rep  varchar(50), Begin_Work decimal (5,2), End_Work decimal (5,2))

Insert...

Reorder where clause:

      p.void = 0 

and l.paymentid is null

and p.authdate between @sdate and @edate

and isnull (p.processor, 'Processed') = 'Procesed'

and p.amount != 0