Entering TIME into excel...

  • Thread starter Thread starter SooHunter
  • Start date Start date
S

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
 
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.
 
Back
Top