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

  • Thread starter Thread starter Stuck Again
  • Start date Start date
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!!!!!!
 
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
Click to expand...

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.
 
Back
Top