text in a function

O

oxicottin

Hello, I need help on a formula? let say im using =SUM(A1:B1) and when i
put numbers in those cells I want it to say *Hrs* at the end of the
total in C1. How do i add that in the formula?Thanks
 
P

Paul B

here is one way,
=SUM(A1:B1) & " Hrs"

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
R

Roger Govier

Hi
Another way which would allow you to use the result of your Sum in a
further calculation would be to format the sell with the Sum formula
Format>Cells>Number>Custom and in the white pane enter #,## "Hrs"

--
Regards

Roger Govier



Paul said:
here is one way,
=SUM(A1:B1) & " Hrs"


"oxicottin" <[email protected]>
wrote in message
Click to expand...

Another way which will still allow you to use the value from your Sum
function in another calcualtion would be
 
Top