Courses discount late-afternoon rounds because fewer holes can be finished before dark. An IF compares the tee time hour with the twilight start and returns the discounted green fee only when the round qualifies.
A 4 p.m. tee time (hour 16) against a $85 green fee with a 40% twilight discount costs $51.00, saving $34.00.
The example
Three worked examples. Change any yellow input in the practice workbook and the results recalculate.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Case | Hour | Green fee | Twilight at | Discount | Fee charged | Savings |
| 2 | Morning | 9 | $85 | 15 | 40.0% | $85.00 | $0.00 |
| 3 | Midday | 14 | $85 | 15 | 40.0% | $85.00 | $0.00 |
| 4 | Twilight | 16 | $85 | 15 | 40.0% | $51.00 | $34.00 |
The formula
Here is the formula, built directly from the inputs:
How it works
Here is the logic, one piece at a time:
B2>=D2tests whether the round is in twilight.C2*(1-E2)is the discounted fee.C2is the full fee otherwise.C2-F2shows the golfer's savings.
Keep every number in its own input cell so the formula never needs editing.
Try it: interactive demo
Enter the values below.
Variations
Seasonal start
Move the twilight hour in winter.
Flat twilight fee
Charge a flat $45 instead.
Pitfalls & errors
Use 24-hour time: 4 p.m. is 16, not 4.
Move the twilight hour as daylight changes through the season.
Show the twilight start on the booking page.
Practice workbook
Frequently asked questions
Can I use minutes?
Does it work for the range?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class