Entering TIME into excel...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SooHunter - 07 Feb 2008 19:42 GMT

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

Reply to this Message

Gord Dibben - 07 Feb 2008 19:52 GMT

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

>I have created a huge spread sheet for monitoring times and delays which are
>entered multiple times everyday, 24-7.
[quoted text clipped - 11 lines]
>
>TOM

Reply to this Message

reitanospa1@yahoo.com - 07 Feb 2008 20:10 GMT

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.

> Cannot be done by simple formatting.
>
[quoted text clipped - 30 lines]
>
> >TOM

Reply to this Message