How to Increment Time using EXCEL ??

[Crackles McFarly]

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,

 

[Joel]

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

 

[Dave Peterson]

Check your other post, too.

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,

 

[Stan Brown]

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.