Places assigned to Seconds + Selecting Special Rows

[Sasha 99]

Hi Guys ,
I have 2 Question
First ::
I want to modify the places assigned to "seconds" from hundredths to tenths as in image illustrated below
https://s22.postimg.org/vj1lgt1td/image.png

...

Seconed ::
I have a table consist of four column , the last column have numbers , its value flactuate between negative & positive number also some cells contain zero
I want to extract the all Rows With ONLY NEGATIVE Number
Example
https://s14.postimg.org/negnxkgjl/image.png

So , is there a quick trick for doing this ?
Thanks

[alansidman]

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[Sasha 99]

That a sample from my table
all what i want is to calculate the difference in Time between Column B & D
Also i want to calculate the difference in Value between Column C & E
Then separate all row which contain negative value in column G
I think it is not too difficult , but really i am not expert in such issues
I appreciate your help to find an answer for my question
Kind regards

[TMS]

Maybe, as a starter, try something like:

Please Login or Register  to view this content.

[Sasha 99]

Thank you very very very much
however the result is not as expected , i make a copy for this formula and the result for 3rd raw was this
-0.430555556

[TMS]

You're welcome. Thanks for the rep.

The "time" in cell B3 is some 10 hours and 20 minutes earlier than the "time" in cell D3. So, if you subtract D3 from B3 you will get a negative value. The numeric time value for 10:20:00 is 0.430555555555556. And, in this case, it will have minus sign. You could use ABS and format the positive result as Time.

[Sasha 99]

Thanks TMS , I got it now

[TMS]

You're welcome.