Remember Me?

#1
September 3rd 09, 04:32 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Sep 2009 Posts: 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?

#2
September 3rd 09, 05:16 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 15,768
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
September 3rd 09, 05:21 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Mar 2009 Posts: 8,521
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?

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Steve Allen Excel Discussion (Misc queries) 4 December 13th 08 03:22 AM Jonathan Bickett Excel Worksheet Functions 5 March 7th 07 06:22 PM Stice Excel Discussion (Misc queries) 1 February 5th 07 10:55 PM [email protected] Excel Worksheet Functions 5 October 1st 06 04:55 PM gschmid Excel Discussion (Misc queries) 2 January 18th 05 02:48 PM

All times are GMT +1. The time now is 06:19 AM.