text in a function
 

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


--
oxicottin
------------------------------------------------------------------------
oxicottin's Profile: http://www.excelforum.com/member.php...o&userid=31702
View this thread: http://www.excelforum.com/showthread...hreadid=514130

text in a function
 

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

"oxicottin" wrote
in message ...

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


--
oxicottin
------------------------------------------------------------------------
oxicottin's Profile:
http://www.excelforum.com/member.php...o&userid=31702
View this thread: http://www.excelforum.com/showthread...hreadid=514130

text in a function
 

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
FormatCellsNumberCustom and in the white pane enter #,## "Hrs"

--
Regards

Roger Govier



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


"oxicottin"
wrote in message
...

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


--
oxicottin
------------------------------------------------------------------------
oxicottin's Profile:
http://www.excelforum.com/member.php...o&userid=31702
View this thread:
http://www.excelforum.com/showthread...hreadid=514130 Hi

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

text in a function
 

Thanks for the help!!!!!!


--
oxicottin
------------------------------------------------------------------------
oxicottin's Profile: http://www.excelforum.com/member.php...o&userid=31702
View this thread: http://www.excelforum.com/showthread...hreadid=514130