I have created a huge spread sheet for monitoring times and delays which are
entered multiple times everyday, 24-7.
The problem is, most people would like to enter the times in a more simple
format such as "military time"... instead of 05:30 PM or 17:30, they would
like to enter 1730. Of course, there are multiple calculations attached to
most all entries, so it is important stability is maintained as well.

I hope there is a way to modify or change a cell format (as the usual
method) I believe allows for self designed formats... I just can't seem to
remember how to do this, or if it is even possible.

Any suggestions, please let me know...
My thanks to all who participate!

TOM

Cannot be done by simple formatting.

Excel has no "input mask" feture.

You will need event code to enter times as you describe.

See Chip Pearson's site for this.

http://www.cpearson.com/excel/DateTimeEntry.htm

Or Bob Phillips' QDE add-in from

http://www.xldynamic.com/source/xld.QDEDownload.html


Gord Dibben MS Excel MVP



On Thu, 7 Feb 2008 11:42:03 -0800, SooHunter
wrote:

I have created a huge spread sheet for monitoring times and delays which are
entered multiple times everyday, 24-7.
The problem is, most people would like to enter the times in a more simple
format such as "military time"... instead of 05:30 PM or 17:30, they would
like to enter 1730. Of course, there are multiple calculations attached to
most all entries, so it is important stability is maintained as well.

I hope there is a way to modify or change a cell format (as the usual
method) I believe allows for self designed formats... I just can't seem to
remember how to do this, or if it is even possible.

Any suggestions, please let me know...
My thanks to all who participate!

TOM

One option would be to create a macro:
either use an INPUTBOX (lots of overhead to the user interface to call
it up, etc)
or pull the data from the cells after it has been entered.

Either way you can capture the two characters on the right, capture
the leftovers on the left and then concatenate them into a time.


On Feb 7, 2:52 pm, Gord Dibben <gorddibbATshawDOTca wrote:
Cannot be done by simple formatting.

Excel has no "input mask" feture.

You will need event code to enter times as you describe.

See Chip Pearson's site for this.

http://www.cpearson.com/excel/DateTimeEntry.htm

Or Bob Phillips' QDE add-in from

http://www.xldynamic.com/source/xld.QDEDownload.html

Gord Dibben MS Excel MVP

On Thu, 7 Feb 2008 11:42:03 -0800, SooHunter

wrote:
I have created a huge spread sheet for monitoring times and delays which are
entered multiple times everyday, 24-7.
The problem is, most people would like to enter the times in a more simple
format such as "military time"... instead of 05:30 PM or 17:30, they would
like to enter 1730. Of course, there are multiple calculations attached to
most all entries, so it is important stability is maintained as well.

I hope there is a way to modify or change a cell format (as the usual
method) I believe allows for self designed formats... I just can't seem to
remember how to do this, or if it is even possible.

Any suggestions, please let me know...
My thanks to all who participate!

TOM