Excel Formula for Scheduling Calculations

[rb-lcecc]

I am working on creating a work schedule for our agency using Excel.  I need to figure out how to assign a numeric value to letters (A=12hour shift) and how to assign a numeric value to another number (1=8hour shift).  it would also be nice to figure out how hours can be totaled if  military time elements are entered into a specific day (Ex:  employee works from 0700-1500 on a specific day;  distinguish those hours and calculate the sum for the week).  any suggestions?

thanks

[#2]

You need to attach your sample file with the data and results you want to achieve.

[#3]

sorry, I am not willing to post my agency's work schedule online anywhere@Twifoo 

[#4]

I was asking for the sample file, not the actual file.