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

M

morgan

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help adding hours exceeding 24 hours 7
Email notifications without opening application 1
Excel does not accept text format! 0
Merging from an Excel file with graphics 1
Force Greyscale on certain Pages in Pub 2016 0
Excel - Wich Function should I use? 1
Start a mail merge upon opening the document 1
Autonumber field in Excel that behaves the same as Access 0

Top