<div>
Hi nampooca<br />
<br />
<br />
To make Excel return a negative time value use this formula<br />
=(B1-A1)*24<br />
<br />
and FYI the result is -25.20<br />
<br />
antrat<br />
<br />

</div>


Hi nampooca


To make Excel return a negative time value use this formula
=(B1-A1)*24

and FYI the result is -25.20

antrat



<div>
<div class="content wysiwyg-content">
How it's possible to make a formula with addition or soustraction time<br />
Exemple<br />
<br />
In Cell A1 I have 128:24:50 content<br />
In cell B1 I have 103:12:50 content<br />
<br />
In C1, I would like to have the soustraction <br />
<br />
B1-A1 in &quot;time&quot; format<br />
<br />
Response : &nbsp;-26:48:00<br />
<br />
It's very important that possible to make sums by columns<br />
<br />
Thanks<br />
<br />
A+<br />

</div>
</div>


How it's possible to make a formula with addition or soustraction time
Exemple

In Cell A1 I have 128:24:50 content
In cell B1 I have 103:12:50 content

In C1, I would like to have the soustraction 

B1-A1 in "time" format

Response :  -26:48:00

It's very important that possible to make sums by columns

Thanks

A+


Soustraction time in excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.