• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Difference Between Two Numbers

Status
Not open for further replies.
Hello

1. I need to do a column that shows how many hours a person worked, if more than 8 hours and less than 10 - to show the excess. - this in one column


2. in the last column I need show by how much the number is greater than 10.

example.

if i have 12 column 1 should 2 and column 2 should be 2
if i have 11 column 1 should 2 and column 2 should be 1
if i have 11.5 column 1 should 2 and column 2 should be 1.5
if i have 9 column 1 should 1 and column 2 should be 0
 
Last edited:
david gabra
Why do You start a new case?
... You didn't answer.
If You would make the original case more clear,
then You should add more information to the original case!

Continue with the original case.
 
Status
Not open for further replies.
Back
Top