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: [TABLE="width: 500"]
<tbody>[TR]
[TD]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Start time[/TD]
[TD]Duration by Minutes[/TD]
[TD]End Time[/TD]
[/TR]
[TR]
[TD]9:00 am[/TD]
[TD]60[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]11:00 am[/TD]
[TD]120[/TD]
[TD]?[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 220"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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

<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>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]30[/TD]

[TD="align: right"]9:30 AM[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="align: right"]11:00 AM[/TD]
[TD="align: right"]120[/TD]

[TD="align: right"]1:00 PM[/TD]

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