Results 1 to 3 of 3
Thread: If, And OR Formula Help
2015-01-02, 05:49 #1
If, And OR Formula Help
I have tried this over and over but just cannot get it to work as I want it to.
If I type a "1" in the "b" column then the times are filled out in the correct boxes from the example attached you can see that in column "I" under Mertid is any hours I work over 6 which is extra hours.
If I type in the B column a "2" then it is overtime for all of that night (bank holidays etc) and the 6 hours is entered into the "J" column.
What I am trying to do is add to the formula in column "I" that if I enter a "2" in the "B" column then the total hours for that day (column F) is entered in the column "I" as well as in the Overtime column.
Thankyou in advance for any help.
2015-01-02, 06:41 #2
- Join Date
- Dec 2000
- Burwash, East Sussex, United Kingdom
- Thanked 187 Times in 173 Posts
Do you mean:
Microsoft MVP - Excel
The Following User Says Thank You to rory For This Useful Post:
2015-01-02, 08:24 #3