Sometimes A4 has less than a whole number such as .5 The .5 is actually 4
hours.
This formula works fine except when there ia a half day.
Here is the formula that sometimes has a half day:
"A4"=IF(DATEDIF(B16,TODAY(),"Y")11,20,VLOOKUP(DAT EDIF(B16,TODAY(),"Y"),K:L,2,0))

"A9"=A4+B3+F4+F5+F6

How can I get this formula to read like (1 Days 4 hours), It now reads
like(1.5 days 0 hours)
Here is the formula giving me the problem
"A12" =A9-CEILING(SUM(HList!D:D)/8,1)&" Days "&MOD(8-SUM(HList!D:D),8)&"
hours"