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,

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,

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

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/