Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a sequential weekly date list, each separated by 5 r | Excel Worksheet Functions | |||
How do I create a list of sequential numbers in Excel 2003? | Excel Discussion (Misc queries) | |||
Create sequential file name for uploaded template | Excel Programming | |||
How do I create a form template that will be sequential numbered | Excel Discussion (Misc queries) | |||
How do I create a list of sequential numbers using Excel or Acces. | Excel Discussion (Misc queries) |