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
|