Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filling a formula in entire column | Excel Discussion (Misc queries) | |||
Auto filling cells in a column | Excel Discussion (Misc queries) | |||
Filling a series into a non-empty column | Excel Worksheet Functions | |||
how to change column references, while filling down another column | Excel Discussion (Misc queries) | |||
Pre-filling column | Excel Discussion (Misc queries) |