View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default 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