How do I create a list of sequential times?

  • Thread starter Thread starter Scarlin3
  • Start date Start date
S

Scarlin3

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
 
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,
 
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 said:
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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top