How do you have a beginning time then use the result of a formula that
calculates a certain # of minutes then adds the minutes to the beginning time
and display the ending time?

How are the minutes calculated? As an integer like: 10 = 10 minutes?

A1 = 12:00 AM
B1 = 10

=A1+B1/1440

Or:

=A1+TIME(0,B1,0)

Format as Time or custom h:mm

--
Biff
Microsoft Excel MVP


"Calculate an ending time" <Calculate an ending
wrote in message
...
How do you have a beginning time then use the result of a formula that
calculates a certain # of minutes then adds the minutes to the beginning
time
and display the ending time?

=A1+TIME(0,22,0)

to add 22 minutes....You can refer that to a cell.. and custom format the
formula cell to [h]:mm (FormatCellsCustomType)

If this post helps click Yes
---------------
Jacob Skaria


"Calculate an ending time" wrote:

How do you have a beginning time then use the result of a formula that
calculates a certain # of minutes then adds the minutes to the beginning time
and display the ending time?

To calculate the end time with the beginning time plus a certain number of minutes:

Use the following formula in Microsoft Excel:
Here's a breakdown of the formula:

1. The HOUR function extracts the hour value from the beginning time.
2. The INT function calculates the number of hours that the formula minutes will add to the beginning time. This value is added to the hour value of the beginning time.
3. The MINUTE function extracts the minute value from the beginning time.
4. The MOD function calculates the remaining minutes after the hours have been added. This value is added to the minute value of the beginning time.
5. The SECOND function extracts the second value from the beginning time.

To use this formula, replace "Beginning Time" with the cell reference of the beginning time and "Formula Minutes" with the number of minutes you want to add. The result will be the end time displayed in the format of "hh:mm:ss AM/PM".

For example, if the beginning time is in cell A1 and you want to add 30 minutes, the formula would be:

This will display the end time in the cell where the formula is entered.