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,