Subtraction of the sums of two columns isn't equal to the sum of their subtractions

**Bkhr** · 04-17-2023, 12:06 PM

Hi, please, please help, this is driving me crazy and I wasted way too much time on it:

I have two columns "col1" and "col2", each one contains time values between 00:00 and 23:59, formatted as "hh:mm".

I have a third column "col3" where, in each row, I subtract the time values of "col1" and "col2" that are in the same row as the cell in "col3".

Capture.PNG

When I calculate

Formula:

Please Login or Register  to view this content.

, I get "17:25" formatted as "[h]:mm".

Capture4.PNG

When I calculate

Formula:

Please Login or Register  to view this content.

, I get "37:10" formatted as "[h]:mm".

Capture3.PNG

!!!!!!!!!

WHAT IS GOING ON??!

**Pepe Le Mokko** · 04-17-2023, 12:25 PM

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**Bkhr** · 04-17-2023, 12:43 PM

here's a sample of my document

**popipipo** · 04-17-2023, 12:55 PM

Negative timevalues are rounded up to zero
The sum of these negative times is the difference.

**Bkhr** · 04-18-2023, 07:02 AM

Thank you!
I removed the IF statement and it gave me reasonable results.

Subtraction of the sums of two columns isn't equal to the sum of their subtractions

LinkBack

Thread Tools

Rate This Thread

Display

Subtraction of the sums of two columns isn't equal to the sum of their subtractions

Re: Subtraction of the sums of two columns isn't equal to the sum of their subtractions

Re: Subtraction of the sums of two columns isn't equal to the sum of their subtractions

Re: Subtraction of the sums of two columns isn't equal to the sum of their subtractions

Re: Subtraction of the sums of two columns isn't equal to the sum of their subtractions

Thread Information

Users Browsing this Thread

Similar Threads

Splitting a data list into 3 equal sums.

Need some help dividing a list of values into groups with equal sums

Green colour if ths sums from two different cells are equal, red if not the same

[SOLVED] Compare Owner Investment and Find not Equal Sums

Divide List of Numbers Into Two Equal Sums

message box if the sums of couple of cells dont equal with the sum of others cel

Pivot report - Hide Sums equal to zero

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions