Adding X# of minutes to time (HH:MM:SS)


S

Stuck Again

I have a long list of times in formatt 10:23:45 (HH:MM:SS). How do I add X
number of minutes to these times?

Ex: 10:23:45 add 4 minutes

Thanks for the help!!!!!!
 
Ad

Advertisements

M

Mike H

Hi,

Try this

=A1+TIME(0,4,0)

and drag down. Ensure the format stays as hh:mm:ss

Mike
 
Ad

Advertisements

J

JoeU2004

Stuck Again said:
I have a long list of times in formatt 10:23:45 (HH:MM:SS).
How do I add X number of minutes to these times?
Ex: 10:23:45 add 4 minutes
Time is stored as a fraction of a day. So you can add 4/1440 (1440 =
24*60).

If you want to add the same amount of time to existing cells in place, you
can put =4/1440 or =TIME(0,4,0) into some cell, then copy that cell (e.g.
ctrl-C), then select the cells to be updated, and right-click Paste Special
Add OK. When you are done, you can delete the value in the cell you copied.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top