If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
filling a column
I'm not an experienced excel user. I'm trying to fill a column with times
beginning with 8:45 AM through 3:00 PM. This is painful. I can fill but the increment is one hour. I need to know how to change it to 5 minutes. Should I just give up and type the numbers in???? |
#2
|
|||
|
|||
filling a column
Enter the first 2 cells manually, then select *both*, and drag down.
8:45 8:50 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Mary M." Mary wrote in message ... I'm not an experienced excel user. I'm trying to fill a column with times beginning with 8:45 AM through 3:00 PM. This is painful. I can fill but the increment is one hour. I need to know how to change it to 5 minutes. Should I just give up and type the numbers in???? |
#3
|
|||
|
|||
filling a column
Assume column is A
In A1 enter 8:45 AM In A2 enter =A1+5/1440 Drag/copy down to 3:00 PM Gord Dibben MS Excel MVP On Tue, 18 Aug 2009 15:22:01 -0700, Mary M. Mary wrote: I'm not an experienced excel user. I'm trying to fill a column with times beginning with 8:45 AM through 3:00 PM. This is painful. I can fill but the increment is one hour. I need to know how to change it to 5 minutes. Should I just give up and type the numbers in???? |
#4
|
|||
|
|||
filling a column
One way:
=TIME(8,45+(ROW()-1)*5,0) I started in Row 1, so I wanted 8:45 there. If I started in row 10, then I'd subtract 10 =TIME(8,45+(ROW()-10)*5,0) And drag down. Then when you're done, convert the formulas to values. Select the range edit|copy Edit|paste special|values Mary M. wrote: I'm not an experienced excel user. I'm trying to fill a column with times beginning with 8:45 AM through 3:00 PM. This is painful. I can fill but the increment is one hour. I need to know how to change it to 5 minutes. Should I just give up and type the numbers in???? -- Dave Peterson |
#5
|
|||
|
|||
filling a column
In article ,
Gord Dibben gorddibbATshawDOTca wrote: Assume column is A In A1 enter 8:45 AM In A2 enter =A1+5/1440 Drag/copy down to 3:00 PM Gord Dibben MS Excel MVP On Tue, 18 Aug 2009 15:22:01 -0700, Mary M. Mary wrote: I'm not an experienced excel user. I'm trying to fill a column with times beginning with 8:45 AM through 3:00 PM. This is painful. I can fill but the increment is one hour. I need to know how to change it to 5 minutes. Should I just give up and type the numbers in???? As another user of Excel who only uses it in a quite simple manner compared to some of you power users... Firstly, thanks for the above solution, and now to my question. I have a column of times, increasing in 5 minute time increments from 8:00 to 10:00 (2 hours) if I SUM that column I get a time of 9:00 Bhaaa! so I'm an idiot. What do I need to do to total that column and get the correct answer of 2 hours? Thanks Dave -- |
#6
|
|||
|
|||
filling a column
A1 is 8:00 AM
A25 is 10:00 AM =(A25-A1)*24 returns 2 when formatted as General Gord On Wed, 19 Aug 2009 09:05:17 +0100, Dave Symes wrote: In article , Gord Dibben gorddibbATshawDOTca wrote: Assume column is A In A1 enter 8:45 AM In A2 enter =A1+5/1440 Drag/copy down to 3:00 PM Gord Dibben MS Excel MVP On Tue, 18 Aug 2009 15:22:01 -0700, Mary M. Mary wrote: I'm not an experienced excel user. I'm trying to fill a column with times beginning with 8:45 AM through 3:00 PM. This is painful. I can fill but the increment is one hour. I need to know how to change it to 5 minutes. Should I just give up and type the numbers in???? As another user of Excel who only uses it in a quite simple manner compared to some of you power users... Firstly, thanks for the above solution, and now to my question. I have a column of times, increasing in 5 minute time increments from 8:00 to 10:00 (2 hours) if I SUM that column I get a time of 9:00 Bhaaa! so I'm an idiot. What do I need to do to total that column and get the correct answer of 2 hours? Thanks Dave |
#7
|
|||
|
|||
filling a column
In article ,
Gord Dibben gorddibbATshawDOTca wrote: A1 is 8:00 AM A25 is 10:00 AM =(A25-A1)*24 returns 2 when formatted as General Gord On Wed, 19 Aug 2009 09:05:17 +0100, Dave Symes wrote: [Snip] As another user of Excel who only uses it in a quite simple manner compared to some of you power users... Firstly, thanks for the above solution, and now to my question. I have a column of times, increasing in 5 minute time increments from 8:00 to 10:00 (2 hours) if I SUM that column I get a time of 9:00 Bhaaa! so I'm an idiot. What do I need to do to total that column and get the correct answer of 2 hours? Thanks, that works a treat. Dave -- |
Thread Tools | |
Display Modes | |
|
|