How to assign a value to a word /text in excel?

**liliherrera** · 03-30-2013, 11:44 PM

I'm really desperate right now! I hope you can help me. So, I'm doing a HW about scheduling the thing here is that I want to have the total hrs the employees are working, what I want to do is to write down breakfast (6), lunch (5.5) or dinner (6.5) and then have the amount of hrs they are working. So I want B22 to add all the total hours all my employees worked together...is that possible?

PLEASE HELP ME!

Screen Shot 2013-03-31 at 00.26.39.png

**rcm** · 03-30-2013, 11:52 PM

could you send the excel sample?

**liliherrera** · 03-30-2013, 11:59 PM

Sure...sorry about that :C Thanks for replying! I really appreciate it I really do!

**liliherrera** · 03-31-2013, 12:17 AM

I have a few more things in this spreadsheet, hope that helps

**FDibbins** · 03-31-2013, 12:29 AM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread..

http://www.excelforum.com/excel-form...d-a-value.html

Thread Closed.