View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
hans bal(nl)
 
Posts: n/a
Default Formula to add text after a sum

use =Sum(G2:G364)&" hrs"

Be aware that this converts the rsult into text, which cannot be used a
value anymore.

Hans

"Robb @ FLW" wrote:

I have a time calculated cell for example =Sum(G2:G364) my result is 210
minutes, then I have another cell that divides it by 60 with a result of 3.5
I would like to add the hrs indicator behind this so that I will see 3.5 hrs

Thank you in advance for any assistance that you can provide
--
Robb