Soustraction time in excel

How it's possible to make a formula with addition or soustraction time

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


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hi nampooca

To make Excel return a negative time value use this formula

and FYI the result is -25.20



Here's a bit more information for you

XL: Negative Date/Time Value Displayed as Pound Signs (###)

The information in this article applies to:

Microsoft Excel for Windows, versions 2.10c, 2.10d, 3.0, 3.0a, 4.0, 4.0a, 5.0, 5.0c
Microsoft Excel for the Macintosh, versions 2.20, 2.2a, 3.0, 3.0a, 4.0, 5.0, 5.0a
Microsoft Excel for Windows 95, versions 7.0, 7.0a
Microsoft Excel 97 for Windows


If Microsoft Excel is set to use the 1900 date system, and you add or subtract data that is formatted with a time format, the date may not be displayed as you expect. When the results of the formula produce a negative value, and this data is formatted to display a time value, the cell displays pound signs, as in the following example:


Although the formula in the cell performs the correct operation, the number format returns the wrong results.

To display the number correctly, use either of the following methods:

Change the date system to the 1904 date system.


Use the following to change the displayed result
where A1 has a value smaller than A2.

The above formula will display the value as text. You may need to format the cell alignment to right justified. Note that this is not an acceptable workaround if you need to use the result in another calculation.

Additional query words: 2.00 2.01 2.10 2.10c 2.10d 2.20 3.00 4.00 4.00a 8.00 97 XL97 XL7 XL5 XL4 XL3

Keywords : kbdta xlformat xlformula
Version : MACINTOSH:2.20,2.2a,3.0,3.0a,4.0,5.0,5.0a; WINDOWS:2.10c,2.10d,3.0,3.0a,4.0,4.0a,5.0,5.0c,7.0,7.0a
Issue type : kbprb

Last Reviewed: October 30, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use



Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
nampoocaAuthor Commented:
Thanks very well
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.