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