View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Calculate Ending time using Start Time and Elapsed Time

With start time (hh:mm) in A1 and elapsed time (decimal hours) in B1,
put this in C1:

=A1 + B1/24

and format the cell as [hh]:mm

Hope this helps.

Pete

On May 13, 1:26*pm, Chief 711 <Chief
wrote:
I have a data base pull that shows a starting time in hh:mm military format,
and an elapsed time in number format (i.e. 30 minutes *equals .50). I am
trying to find an equatioin that will add the Starting time and the elapsed
time and show me an ending time in hh.mm military format.