Time Calculation Formula

[mizzmeeshelly]

Hi all,

I have a column with the start time and a column with a minute duration. Can you help me put that into a formula on the next column that calculate the "end time"?

Ex:

Start time Duration by Minutes End Time 9:00 am 60 ? 11:00 am 120 ? <tbody> </tbody>

<tbody>
</tbody>

<tbody>
</tbody>

Thank you.

 

[MARK858]

Maybe...

Excel Workbook
	A	B	C	D
1	9:00 AM	30		9:30 AM
2	11:00 AM	120		1:00 PM
Sheet1

Although strictly speaking you don't need the brackets

 

[mizzmeeshelly]

It works! Thank you so much!!

Maybe...

Sheet1

	A	B	C	D
1	9:00 AM	30		9:30 AM
2	11:00 AM	120		1:00 PM

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:182px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula D1 =A1+(B1/1440) D2 =A2+(B2/1440) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Although strictly speaking you don't need the brackets