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.

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.

Ben,
Yes, 6 would be the default. We use three shifts here, one 9 to 6, one 10 to
7 and one 12 to 9. So with the initial VB information, I am hoping to be able
to cover each of those options so that if I enter 09:00 into the cell, it
displays 9 - 6, 10:00 would display 10 - 7, and 12:00 would display 12 - 9.
I am out of my element as far as starting the creation of the script, or
code (not sure what the correct term would be) So far, deciding what code I
need to even start the process, and where it would reside ( I am guessing in
the "This WorkBook" module )
Appreciate any direction that can be provided.

"ben" wrote:

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.