several ways, there is the possibility of using the format method to create
it the way you want in VB but it is possible to us the format worksheet
function with vb. one question if someone types in 9:00 and you want it 9-6
how do you know where the six comes from? or is that default

"Fleone" wrote:

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.