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

--