| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add colon to time automatically, still recognize it as time
Good morning! I need to type 0125 into a cell and it automatically add the colon (01:25 or 1:25- Either works). I have found several solutions to this BUT I also need Excel to still recognize the cell as "Time" so I can figure elapsed time in another cell. Thank you!
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding a colon to military time | Excel Worksheet Functions | |||
| Need to add semi colon in time numbers | Excel Discussion (Misc queries) | |||
| Editing time that has its colon removed | Excel Worksheet Functions | |||
| Military Time & Colon | Excel Worksheet Functions | |||
| How can Excel do daily timesheet, -lunch time, & not use colon in. | Excel Worksheet Functions | |||
Threaded Mode
