Excel Increment time hour / minutes 2

[mrn]

Hi

I'm trying to fill a time column in Excel as follows

19:58
19:59
20:00
21:01
21:02

Is there an easy way to do this rather than typing each line for a 24 hour period?

Mike

"Whenever I dwell for any length of time on my own shortcomings, they gradually begin to seem mild, harmless, rather engaging little things, not at all like the staring defects in other people's characters."

 

[PHV]

Have a look at the AutoFill method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[GlennUK]

The fill handle will do all the work for you if you fill in the first 2 cells 0:01 0:02, and pull down. It took me 5 seconds to fill 24 hours ( 1439 cells ).

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[SkipVought]

FYI...

Check out

Why do Dates and Times seem to be so much trouble? faq68-5827

Skip,

_[red][/red]

 

[mrn]

Thanks but the autofill does the following

0:01
0:02
0:03 <- start drag
1:03
2:03
3:03


Mike

"Whenever I dwell for any length of time on my own shortcomings, they gradually begin to seem mild, harmless, rather engaging little things, not at all like the staring defects in other people's characters."

 

[mrn]

Ok did it

Col A 0001
Col B =TIMEVALUE(IF(A3<1000, LEFT(A3,1),LEFT(A3,2))&":"&RIGHT(A3,2))

Mike

"Whenever I dwell for any length of time on my own shortcomings, they gradually begin to seem mild, harmless, rather engaging little things, not at all like the staring defects in other people's characters."

 

[combo]

With autofill:

00:01 | <- select 00:01 and 00:02
00:02 _| <- and start drag
00:03
00:04

combo

 

[GlennUK]

Like combo said. ( which I should have clarified, of course, d'oh!!! )

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[mrn]

Ahhhh! Thanks that works

Mike

"Whenever I dwell for any length of time on my own shortcomings, they gradually begin to seem mild, harmless, rather engaging little things, not at all like the staring defects in other people's characters."