View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul B
 
Posts: n/a
Default 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