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.