How to Increment Time using EXCEL ??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Crackles McFarly - 19 Aug 2007 19:48 GMT

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,

Reply to this Message

Joel - 19 Aug 2007 20:08 GMT

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

> I'm using, and love it, Excel 97. I want to know how to increment
> TIME.
[quoted text clipped - 8 lines]
> Does anyone of you know how to do this? I'd sure appreciate the help.
> thanks,

Reply to this Message

Dave Peterson - 19 Aug 2007 20:30 GMT

Check your other post, too.

> I'm using, and love it, Excel 97. I want to know how to increment
> TIME.
[quoted text clipped - 8 lines]
> Does anyone of you know how to do this? I'd sure appreciate the help.
> thanks,

Signature

Dave Peterson

Reply to this Message

Stan Brown - 20 Aug 2007 07:46 GMT

Sun, 19 Aug 2007 14:48:23 -0400 from Crackles McFarly
<IrelandSux@ireland.sux>:

> 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.

Signature

"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 to this Message