ExcelBanter - Need formula to avoid ":" in cells with tt:mm

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Need formula to avoid ":" in cells with tt:mm (https://www.excelbanter.com/excel-worksheet-functions/6693-need-formula-avoid-%22-%22-cells-tt-mm.html)

morgan

Need formula to avoid ":" in cells with tt:mm

Using excel to register start and stop , registered by tt:mm. Is there any
way to formate the cells, so I can type ttmm, and excel will show tt:mm?? Not
a big deal, but will make my day happier.....

Frank Kabel

Hi
only possible with VBA. See:
http://cpearson.com/excel/DateTimeEntry.htm

"morgan" wrote:

Using excel to register start and stop , registered by tt:mm. Is there any
way to formate the cells, so I can type ttmm, and excel will show tt:mm?? Not
a big deal, but will make my day happier.....

morgan

Thank You!!!

Frank Kabel skrev:

Hi
only possible with VBA. See:
http://cpearson.com/excel/DateTimeEntry.htm

"morgan" wrote:

Using excel to register start and stop , registered by tt:mm. Is there any
way to formate the cells, so I can type ttmm, and excel will show tt:mm?? Not
a big deal, but will make my day happier.....

All times are GMT +1. The time now is 11:24 PM.