software

I would like a formula to add 15 minutes to a column of times formatted as:
h:mm:ss AM/PM, so if:

A1 were equal to 5:00:00 PM, I would like a formula for B1 to produce
5:15:00 PM.
put 0:15:00 in an empty cell, format it the same way the cells you want to
add to, copy it, select all cells and do editgt;paste special and select add

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Jayequot; gt; wrote in message
...
gt;I would like a formula to add 15 minutes to a column of times formatted as:
gt;h:mm:ss AM/PM, so if:
gt;
gt; A1 were equal to 5:00:00 PM, I would like a formula for B1 to produce
gt; 5:15:00 PM.
gt;Hi!

Enter this in B1:

=A1 TIME(0,15,0)

Or:

=A1 15/1440

Or:

If you want to do it in place:

In an empty cell enter:

=15/1440

Then, copy that cell. Now, select the range of time entries in column A.
Then do Editgt;Paste Specialgt;Addgt;OK.

Reformat the cells as TIME. Delete the helper cell.

Biff

quot;Jayequot; gt; wrote in message
...
gt;I would like a formula to add 15 minutes to a column of times formatted as:
gt;h:mm:ss AM/PM, so if:
gt;
gt; A1 were equal to 5:00:00 PM, I would like a formula for B1 to produce
gt; 5:15:00 PM.
gt;
On Tue, 10 Jan 2006 22:18:56 -0500, quot;Jayequot; gt; wrote:

gt;I would like a formula to add 15 minutes to a column of times formatted as:
gt;h:mm:ss AM/PM, so if:
gt;
gt;A1 were equal to 5:00:00 PM, I would like a formula for B1 to produce
gt;5:15:00 PM.
gt;

=A1 time(0,15,0)--ron