Reading Text and numbers

[Guest]

Is there a way to read these to formuas and give the results as Numbers and
Text.
A6=INT(A4+B3+F4+F5+F6) & " Days " & MOD(A4+B3+F4+F5+F6,1)*8 & " hours"

A10=INT(SUM(HList!D)/8)&" Days "&MOD(SUM(HList!D),8) &" hours"

I'm subtracting A6 from A10
In A12 the results should be something like 4 Days 4 hours

 

[raypayette]

Using a macro you could parse the data, make the calculation and give
the result.
I think it would be easier for you to split the days and hours in 2
separate cells!