Reading Text and numbers
 

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:D)/8)&" Days "&MOD(SUM(HList!D:D),8) &" hours"

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

Reading Text and numbers
 

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!


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=571017