Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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:
  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:

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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default 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?



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate total time(hours/minutes) from text/custom format column Steve Allen Excel Discussion (Misc queries) 4 December 13th 08 03:22 AM
Formula to find Stop Time from Start Time and Total Minutes Jonathan Bickett Excel Worksheet Functions 5 March 7th 07 06:22 PM
calculate time in days:hours:minutes Stice Excel Discussion (Misc queries) 1 February 5th 07 10:55 PM
to calculate the difference between sign in and signout time in minutes. [email protected] Excel Worksheet Functions 5 October 1st 06 04:55 PM
How do I set up a formula on a time sheet to calculate time in 1/. gschmid Excel Discussion (Misc queries) 2 January 18th 05 02:48 PM


All times are GMT +1. The time now is 08:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"