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

Formatting question: how to format duration (time spent)? 0
Excel does not accept text format! 0
Subtracting Military Time 3
Autonumber field in Excel that behaves the same as Access 0
Entering time 1
Countdown macro - display settings 2
Difference between 2 dates&time(format 0000), and excludes weekend 1
Formatting Time 7

Top