formatting cells for time

R

rjpalmateer

How do you format cells for time so that you can enter only the numbers and
not the colon? We have a ss that we enter many times and it would be much
faster if we didn't have to enter the colons.
 

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

Subtracting Military Time 2
Average time 15
Time and Date Entry Shortcuts? 5
Entering time 1
Excel Conditional Formatting 1
convert standard number to time format 1
Formatting Time 7
Input Mask - quick question 6

Top