Add 15 minutes

J

Jaye

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.
 
P

Peo Sjoblom

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

--
Regards,

Peo Sjoblom

Portland, Oregon
 
B

Biff

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 Edit>Paste Special>Add>OK.

Reformat the cells as TIME. Delete the helper cell.

Biff
 
R

Ron Rosenfeld

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.
Click to expand...

=A1+time(0,15,0)


--ron
 
Top