Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheetfunctions,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you Increment Time by varrying times???
I'm using, and love it, Excel 97. I want to know how to increment
TIME. Say I have a few rows, each start at 10:00 AM and I want each to increment at different intervals. Let's say row 1 is 15 min, row 2 is 17 minutes, row 3 is 60 minutes, row 4 is 75 minutes, etc..etc.. I cannot find documentation about this within Excel NOR on Microsoft's web site. Does anyone of you know how to do this? I'd sure appreciate the help. thanks, |
#2
Posted to microsoft.public.excel.worksheetfunctions,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you Increment Time by varrying times???
To increment by different intervals, you will need to enter a formula for each,
because Excel will not be able to guess the proper interval. You can build the increment into the formula, as in: =a1+time(0,15,0) =a2+time(0,17,0) etc. or, enter the interval in a separate column (say B), then add it to that row's time, as in: =a1+b2 which you can then copy down. -- Regards, Fred "Crackles McFarly" wrote in message ... I'm using, and love it, Excel 97. I want to know how to increment TIME. Say I have a few rows, each start at 10:00 AM and I want each to increment at different intervals. Let's say row 1 is 15 min, row 2 is 17 minutes, row 3 is 60 minutes, row 4 is 75 minutes, etc..etc.. I cannot find documentation about this within Excel NOR on Microsoft's web site. Does anyone of you know how to do this? I'd sure appreciate the help. thanks, |
#3
Posted to microsoft.public.excel.worksheetfunctions,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you Increment Time by varrying times???
Check your other posts, too.
Crackles McFarly wrote: I'm using, and love it, Excel 97. I want to know how to increment TIME. Say I have a few rows, each start at 10:00 AM and I want each to increment at different intervals. Let's say row 1 is 15 min, row 2 is 17 minutes, row 3 is 60 minutes, row 4 is 75 minutes, etc..etc.. I cannot find documentation about this within Excel NOR on Microsoft's web site. Does anyone of you know how to do this? I'd sure appreciate the help. thanks, -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheetfunctions,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you Increment Time by varrying times???
On Sun, 19 Aug 2007 13:21:24 -0600, "Fred Smith"
sayd the following: To increment by different intervals, you will need to enter a formula for each, because Excel will not be able to guess the proper interval. You can build the increment into the formula, as in: =a1+time(0,15,0) =a2+time(0,17,0) etc. Wow weeee, thanks sir |
#5
Posted to microsoft.public.excel.worksheetfunctions,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you Increment Time by varrying times???
Dave, which EXCEL newsgroups is most useful, most answers?
I'll try to limit myself to it.. thanks.. On Sun, 19 Aug 2007 14:32:20 -0500, Dave Peterson sayd the following: Check your other posts, too. Crackles McFarly wrote: I'm using, and love it, Excel 97. I want to know how to increment TIME. Say I have a few rows, each start at 10:00 AM and I want each to increment at different intervals. Let's say row 1 is 15 min, row 2 is 17 minutes, row 3 is 60 minutes, row 4 is 75 minutes, etc..etc.. I cannot find documentation about this within Excel NOR on Microsoft's web site. Does anyone of you know how to do this? I'd sure appreciate the help. thanks, |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you Increment Time by varrying times???
See reply in other news groups you posted this to.
Gord Dibben MS Excel MVP On Sun, 19 Aug 2007 17:48:11 -0400, Crackles McFarly wrote: Dave, which EXCEL newsgroups is most useful, most answers? I'll try to limit myself to it.. thanks.. On Sun, 19 Aug 2007 14:32:20 -0500, Dave Peterson sayd the following: Check your other posts, too. Crackles McFarly wrote: I'm using, and love it, Excel 97. I want to know how to increment TIME. Say I have a few rows, each start at 10:00 AM and I want each to increment at different intervals. Let's say row 1 is 15 min, row 2 is 17 minutes, row 3 is 60 minutes, row 4 is 75 minutes, etc..etc.. I cannot find documentation about this within Excel NOR on Microsoft's web site. Does anyone of you know how to do this? I'd sure appreciate the help. thanks, |
#7
Posted to microsoft.public.excel.worksheetfunctions,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you Increment Time by varrying times???
Gord responded to your other post, but the question should be "which excel
newsgroups are most appropriate". If you have programming questions, then .programming if you have worksheet functions, then .worksheet.functions if you have charting questions, then .charting if you have setup questions, then .setup if you're a newuser, then .newusers ..misc for miscellaneous stuff. and there are lots of .excel newsgroups, too: ..links ..templates ..printing ..mac.office.excel and more But those top 5 of 6 get read by most regulars (I bet). .Charting may not be read by all, but it's read by the really smart charting people. Crackles McFarly wrote: Dave, which EXCEL newsgroups is most useful, most answers? I'll try to limit myself to it.. thanks.. On Sun, 19 Aug 2007 14:32:20 -0500, Dave Peterson sayd the following: Check your other posts, too. Crackles McFarly wrote: I'm using, and love it, Excel 97. I want to know how to increment TIME. Say I have a few rows, each start at 10:00 AM and I want each to increment at different intervals. Let's say row 1 is 15 min, row 2 is 17 minutes, row 3 is 60 minutes, row 4 is 75 minutes, etc..etc.. I cannot find documentation about this within Excel NOR on Microsoft's web site. Does anyone of you know how to do this? I'd sure appreciate the help. thanks, -- Dave Peterson |
#8
Posted to microsoft.public.excel.worksheetfunctions,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you Increment Time by varrying times???
Mo' better response than "any Excel news group"
Gord On Sun, 19 Aug 2007 18:52:38 -0500, Dave Peterson wrote: Gord responded to your other post, but the question should be "which excel newsgroups are most appropriate". If you have programming questions, then .programming if you have worksheet functions, then .worksheet.functions if you have charting questions, then .charting if you have setup questions, then .setup if you're a newuser, then .newusers .misc for miscellaneous stuff. and there are lots of .excel newsgroups, too: .links .templates .printing .mac.office.excel and more But those top 5 of 6 get read by most regulars (I bet). .Charting may not be read by all, but it's read by the really smart charting people. Crackles McFarly wrote: Dave, which EXCEL newsgroups is most useful, most answers? I'll try to limit myself to it.. thanks.. On Sun, 19 Aug 2007 14:32:20 -0500, Dave Peterson sayd the following: Check your other posts, too. Crackles McFarly wrote: I'm using, and love it, Excel 97. I want to know how to increment TIME. Say I have a few rows, each start at 10:00 AM and I want each to increment at different intervals. Let's say row 1 is 15 min, row 2 is 17 minutes, row 3 is 60 minutes, row 4 is 75 minutes, etc..etc.. I cannot find documentation about this within Excel NOR on Microsoft's web site. Does anyone of you know how to do this? I'd sure appreciate the help. thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Increment Time using EXCEL ?? | New Users to Excel | |||
Increment formula for time | Excel Discussion (Misc queries) | |||
calculate varrying formulas | Excel Discussion (Misc queries) | |||
An uneven time-increment | Charts and Charting in Excel | |||
Time and Date increment | Excel Discussion (Misc queries) |