| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
INPUTING TIME FORMAT
I was wondering if there is a way to be able to type in 4 number eg 1245 and
the cell to automatically format this to hh:mm ie 12:45. many thanks, Rob |
|
#2
|
|||
|
|||
|
Try this, Rob:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=75 ******************* ~Anne Troy www.OfficeArticles.com "Rob" wrote in message ... I was wondering if there is a way to be able to type in 4 number eg 1245 and the cell to automatically format this to hh:mm ie 12:45. many thanks, Rob |
|
#3
|
|||
|
|||
|
This works beautifully thanks.
"Anne Troy" wrote in message news:c746b$42d91f08$97c5108d$25666@allthenewsgroup s.com... Try this, Rob: http://www.vbaexpress.com/kb/getarticle.php?kb_id=75 ******************* ~Anne Troy www.OfficeArticles.com "Rob" wrote in message ... I was wondering if there is a way to be able to type in 4 number eg 1245 and the cell to automatically format this to hh:mm ie 12:45. many thanks, Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding time | Excel Discussion (Misc queries) | |||
| convert number to time format? | Excel Discussion (Misc queries) | |||
| subtraction with time format cells | Excel Worksheet Functions | |||
| Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions | |||
| Subtracting time in date format | Excel Worksheet Functions | |||
Linear Mode
