How do you add minutes to a time cell?

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

I have a cell (General Format) with a start time that says:

11:00:00 AM.

I want to add 30 minutes to this time to get an end time (11:30:00 AM) and do so adding 30 minutes to a long column of start times. (This has to do with importing a calendar exported to Excel and back into Outlook.)

What is the formula for adding 30 minutes (or any other number of minutes) to a start time?

Thank you.

Peter
 
XL stores times as fractional days, so to get minutes, you need to
divide by (24*60) or 1440:


A1: 11:00:00 AM
A2: =A1+30/1440 ==> 11:30:00

or, using the Time function:

A2: =A1 + TIME(0,30,0) ==> 11:30:00
 
Thank you. It sure is easy when you know how!!

Note final step: reformat as a "time" cell.
 
Back
Top