If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




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? 
Ads 
#2




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? 
#3




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 (FormatCells>Custom>Type) 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? 
Thread Tools  
Display Modes  


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 02:22 AM 
Formula to find Stop Time from Start Time and Total Minutes  Jonathan Bickett  Excel Worksheet Functions  5  March 7th 07 05:22 PM 
calculate time in days:hours:minutes  Stice  Excel Discussion (Misc queries)  1  February 5th 07 09: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 01:48 PM 