text in a function

[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

[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

"oxicottin" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[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 B wrote:
> here is one way,
> =SUM(A1:B1) & " Hrs"
>
>
> "oxicottin" <[email protected]>
> wrote in message
> news:[email protected]...
>>
>> 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

[oxicottin]

Thanks for the help!!!!!!