SUMIFs Formula - Converting Hours to Days to use as criteria

Hi everyone! This is my first post here but I'm a longtime lurker. I struggle with explaining excel issues, so I will try my best!

I have 2 Sheets - my end goal is to find the number of submittals (recorded in column C - TTF tab) and sum those values if the Date Raised (column D) + Time to Fill (column B) is within the date range on my summary tab. The issue is that Time to Fill is in hours and I need it to be converted to days within the formula. I do not want to add any columns to my TTF tab because I'm trying to make my project extremely automatic without adding additional columns or using macros. That being said - I dont know if what I want can be done.

Just for reference TTF is a table named TTFTable. I'm trying to do this through table references. Here is the code that does not work - I've attached a screen shot of the error I get. (I am trying to sum positions filled in june, so anything >5/31 and <=6/30) Whenever I open the functions tab, I do not see a #Value error. I've also attached the workbook for reference.

=SUMIFS(TTFTable[@['# Submittals Submitted]],TTFTable[@[Date raised]]+(TTFTable[@[Time To Fill (Hours)]]/24),">"&Summary!D1,TTFTable[@[Date raised]]+(TTFTable[@[Time To Fill (Hours)]]/24),"<="&Summary!E1)

Thanks everybody!