How do I enter mins and secs in Excel without using caps/colon

A

Alphie

Using Excell, I need to fill columns with minutes and seconds (ie 10:22).
Having to use caps and colon to insert the colon between the minute and
seconds is time consuming, is there any way round this anybody please?
 
F

Fred Smith

Two options:

1. Enter the data in one cell, and use a formula to convert it to a time in
another:
=time(0,int(a1/100),mod(a1,100))
2. Use an event macro to convert it in place.

If you want the event macro, post a request in the .programming group.

Regards,
Fred
 

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

Can I enter a 24 hour time without typing colon? 2
Cumulative time calculation in Excel 2003 2
Excel How to enter hour and minutes in Excel without keying the colon 2
How do I insert a colon so a string of numbers is recogized as a t 1
Charting times in EXCEL in 24 hr basis without colon 2
how can i convert a value quoted in hrs,mins,secs to just mins 1
How do I make some columns all caps and others proper? 2
How do I show Latitude and Longitude in Excel Table 1

Top