I would like to know if I can use a VB module/script/something in a workbook
that will change the information that a cell displays according to the data
that is placed in the cell.
What I am trying to accomplish is working with a schedule. I would like to
be able to type 09:00 into a cell, but have it displayed as 9 - 6
representing the fact that a shift that starts at 9:00am would run from 9 am
to 6 pm.
I admit that I am basically clueless where VB is involved, and most of my
experience with it has dealt with using others code and modifying it to meet
my specific needs.
I am fairly handy with creating Macros, but have no idea where to even begin
with something like this.

Thanks in advance for your advice.