ExcelBanter - How calculate end time with beginning time plus formula minutes

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How calculate end time with beginning time plus formula minutes (https://www.excelbanter.com/excel-worksheet-functions/241553-how-calculate-end-time-beginning-time-plus-formula-minutes.html)

How calculate end time with beginning time plus formula minutes

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?

Answer: How calculate end time with beginning time plus formula minutes

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

Use the following formula in Microsoft Excel:

Formula:


		
			
=TIME(HOUR(Beginning Time)+INT((Formula Minutes+MINUTE(Beginning Time))/60),MOD((Formula Minutes+MINUTE(Beginning Time)),60),SECOND(Beginning Time))

Here's a breakdown of the formula:

The HOUR function extracts the hour value from the beginning time.
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.
The MINUTE function extracts the minute value from the beginning time.
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.
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:

Formula:


		
			
=TIME(HOUR(A1)+INT((30+MINUTE(A1))/60),MOD((30+MINUTE(A1)),60),SECOND(A1))

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

How calculate end time with beginning time plus formula minutes

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?

How calculate end time with beginning time plus formula minutes

=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?