david gabra
Member
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
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: