Entering TIME into excel...

[SooHunter]

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

 

[Gord Dibben]

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

 

[reitanospa1]

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.