Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter mins and secs in Excel without using caps/colon
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter mins and secs in Excel without using caps/colon
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 "Alphie" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter mins and secs in Excel without using caps/colon
Note that if you put in 10:22, that is 10 hours and 22 minutes. If you want
minutes and seconds, try 0:10:22 or 10:22.0 -- David Biddulph "Alphie" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to sum hours, mins, secs (00:00:00)? | Excel Discussion (Misc queries) | |||
Format Cells for Mins / Secs | Excel Worksheet Functions | |||
how can i convert a value quoted in hrs,mins,secs to just mins | Excel Worksheet Functions | |||
Importing Mins:Secs | Excel Discussion (Misc queries) | |||
Convert mins:secs to seconds only | Excel Worksheet Functions |