View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
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?