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.