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 editpaste special and select add

--
Regards,

Peo Sjoblom

Portland, Oregon




"Jaye" wrote in message
...
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.

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

Reformat the cells as TIME. Delete the helper cell.

Biff

"Jaye" wrote in message
...
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.

On Tue, 10 Jan 2006 22:18:56 -0500, "Jaye" wrote:

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.


=A1+time(0,15,0)


--ron