time calculations in excel

[luvbite38]

Hey guys,

thanks in advance for your time and the potential solution....

how do you subtract and add time past 24hrs
example

A1 B1(no. of hours to subtract)

00:00 3

answer = 19:00


Example 2


A1 B1(no. of hours to add)

00:00 3

answer = 03:00

Example3:

12:00 + 4

Answer = 16:00

Million and zillions of thanks in advance...

 

[Matt Rogers]

Hi.

Example3 2 suggestions:

<table style="font-family:Arial,Arial; font-size:9pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; " border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight:bold; width:30px; "><col style="width:70.4px;"><col style="width:70.4px;"><col style="width:70.4px;"></colgroup><tbody><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td>
</td><td>A</td><td>B</td><td>C</td></tr><tr style="height:21px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">1</td><td style="text-align:right; ">12:00</td><td style="text-align:right; ">16:00</td><td>
</td></tr><tr style="height:21px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">2</td><td style="text-align:right; ">12:00</td><td style="text-align:right; ">16:00</td><td style="text-align:right; ">4</td></tr></tbody></table>
<table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tbody><tr><td>Spreadsheet Formulas</td></tr><tr><td><table style="font-family:Arial; font-size:9pt;" border="1" cellpadding="2" cellspacing="0"><tbody><tr style="background-color:#cacaca; font-size:10pt;"><td>Cell</td><td>Formula</td></tr><tr><td>B1</td><td>=A1+TIME(4,0,0)</td></tr><tr><td>B2</td><td>=TIME(HOUR(A2)+C2,MINUTE(A2),SECOND(A2))</td></tr></tbody></table></td></tr></tbody></table>