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.
|