| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.newusers
|
|||
|
|||
How to Increment Time using EXCEL ??
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.programming,microsoft.public.excel.newusers
|
|||
|
|||
|
How to Increment Time using EXCEL ??
Time is based on 1 = 1 day.
In cell C1 I put =24/60 and format as a number - this equals 1 minute In cell A4 I put =00:15 and format as time - this euqals 15 minutes In cell B4 I put = A4 + C1 and format as time - I got 00:16 "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, |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel.newusers
|
|||
|
|||
|
How to Increment Time using EXCEL ??
Check your other post, 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.programming,microsoft.public.excel.newusers
|
|||
|
|||
|
How to Increment Time using EXCEL ??
Sun, 19 Aug 2007 14:48:23 -0400 from Crackles McFarly
: I'm using, and love it, Excel 97. I want to know how to increment TIME. Please see the responses in the other newsgroup where you posted, and in the future don't post the same query multiple times. -- "First prove what you're saying, then whine about it." -- /The People's Court/ Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Increment formula for time | Excel Discussion (Misc queries) | |||
| How do I increment a number by1 each time I access it? | Excel Worksheet Functions | |||
| An uneven time-increment | Charts and Charting in Excel | |||
| how to auto increment a number each time i open the worksheet | Excel Worksheet Functions | |||
| Time and Date increment | Excel Discussion (Misc queries) | |||
Linear Mode
