Prev: Conditional Formatting - Test Practice
Next: Copy and paste to the last row
From: Alphie on 6 May 2010 18:13
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?
From: Fred Smith on 6 May 2010 19:15
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" <Alphie(a)discussions.microsoft.com> wrote in message
news:A792F887-A03A-49BA-8564-C40BB920DA56(a)microsoft.com...
> 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?

From: "David Biddulph" groups [at] on 6 May 2010 19:42
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" <Alphie(a)discussions.microsoft.com> wrote in message
news:A792F887-A03A-49BA-8564-C40BB920DA56(a)microsoft.com...
> 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?


 | 
Pages: 1
Prev: Conditional Formatting - Test Practice
Next: Copy and paste to the last row