How do I create a list of sequential times?
 

I need to create a list of start times for groups in a competition. The first
group goes on at 3:00pm. The next group goes on 8 minutes later, the next 8
minutes after that, and so on. It seems this should be a simple formula but
I can't figure it out! Thanks for any help!

Susan

How do I create a list of sequential times?
 

In cell A2 place 3:00:00 PM
In cell A3 place 3:08:00 PM

Highlight A2:A3, autofill down the sheet for about 25-30 rows (with A2:A3
hightlighted autofill by placing the mouse in the lower right corner &
dragging down).

HTH,
--
Data Hog


"Scarlin3" wrote:

I need to create a list of start times for groups in a competition. The first
group goes on at 3:00pm. The next group goes on 8 minutes later, the next 8
minutes after that, and so on. It seems this should be a simple formula but
I can't figure it out! Thanks for any help!

Susan

How do I create a list of sequential times?
 

Hi

Excel stores time as fractions of a day.
Minutes in a day = 24*60 = 1440 so 8 minutes would be 8/144
In cell A1 enter 3:00
in B1=A1+8/1440 and copy down as required
--
Regards
Roger Govier

"Scarlin3" wrote in message
...
I need to create a list of start times for groups in a competition. The
first
group goes on at 3:00pm. The next group goes on 8 minutes later, the next
8
minutes after that, and so on. It seems this should be a simple formula
but
I can't figure it out! Thanks for any help!

Susan

__________ Information from ESET Smart Security, version of virus
signature database 4755 (20100108) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4755 (20100108) __________

The message was checked by ESET Smart Security.

http://www.eset.com

How do I create a list of sequential times?
 

hello,

in A1 put 15:00
in A2 put the formula =A1+"00:08"



"Scarlin3" a écrit dans le message de
groupe de discussion : ...
I need to create a list of start times for groups in a competition. The
first
group goes on at 3:00pm. The next group goes on 8 minutes later, the next
8
minutes after that, and so on. It seems this should be a simple formula
but
I can't figure it out! Thanks for any help!

Susan