need Excell to display something other than what I type

[Guest]

Does anyone know how to ge excel to display something based on what I type?
Example. I want to create a schedule, and Bobby Bofinger works 12-8. next to
his name I would put ---- 12-8 ----. I would like excel to interperate this
as 8, as in 8hours. If I can get excel to recognize 12-8 as 8 hours, I can
then add all the hours for every employee. As it stands, I have to put hours
in as time, ---- 12p ----- and in a separate cell, ------ 8p ------. I just
want excell to know that if I put 12-8, it is 8 and if I put 8-5 it is 9. Is
this even possible?

 

[Guest]

Yes, it's possible
Assuming start time in AM and end time in PM

=MID(A1,FIND("-",A1)+1,9)+12-LEFT(A1,FIND("-",A1)-1)