How to Increment Time using EXCEL ??

  • Thread starter Thread starter Crackles McFarly
  • Start date Start date
C

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,
 
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
 
Check your other post, too.

Crackles said:
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,
Click to expand...
 
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.
Click to expand...

Please see the responses in the other newsgroup where you posted, and
in the future don't post the same query multiple times.
 
Back
Top