Hi Guys! Good day!
I was ask to make a formula to compute for the holiday hours rendered here in our company..
In the column 1 you are only allowed to input numbers between 1 - 8 (which represents 1 hr to 8 hrs of work)
In the column 2 you can only input a data if you have 8 or more in the column 1. If you have less than 8 in the column 1 you are not allowed to input any data on column 2 (column 2 represents overtime hrs in excess of the 8 hrs required)
please help me guys how to go about my problem.
Thank you so much!
Example:
Column 1 |
Column 2 |
7 |
|
8 |
|
8 |
1 |
8 |
2 |
Bookmarks