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.