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