Formula to add text after a sum
Here's one option....
Select the cell...then...
From the Excel main menu:
<format<cells<number tab
Category: Custom
Type: General" hrs"
Click the [OK] button
While the value in the cell will still be numeric, it will display as: 3.5
hrs.
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"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
|