A tee sheet runs from the first tee time to the last, one group every 8, 9 or 10 minutes. How many slots is that? Excel stores a time as a fraction of a day, so the difference between two times, times 1,440, is minutes. Divide by the interval, round down, and add one for the first slot itself — the fence-post problem that trips up every new starter.
7:00 AM to 5:00 PM is 600 minutes. At 9-minute intervals that is 66.7 gaps, so 66 gaps and 67 tee times — 268 players if every group is a foursome.
The example
Three seasons on the same course. Summer daylight stretches the sheet; a winter day squeezes it and a tighter interval claws some of it back.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Season | First tee | Last tee | Interval | Tee times | Players |
| 2 | Spring | 7:00 AM | 5:00 PM | 9 | 67 | 268 |
| 3 | Summer | 6:30 AM | 6:30 PM | 10 | 73 | 292 |
| 4 | Winter | 8:00 AM | 3:00 PM | 8 | 53 | 212 |
The formula
Tee times first, then multiply by four:
How it works
The whole thing hinges on knowing what Excel thinks a time is:
C2-B2is the difference between two time cells. Excel stores 5:00 PM as 0.7083 and 7:00 AM as 0.2917, so the difference is 0.4167 of a day.*1440converts a fraction of a day to minutes (24 hours × 60). 0.4167 × 1,440 is 600./D2divides by the interval. 600 over 9 is 66.67 — the number of gaps between tee times, not tee times.ROUNDDOWN(...,0)+1keeps whole gaps and adds the first slot. 66 gaps means 67 tee times, from 7:00 to 4:54.
Multiply by four for the theoretical player capacity; then multiply by the green fee and you have the revenue the sheet could produce on a full day, which is the number to measure real days against.
Try it: interactive demo
Enter the first and last tee time (24-hour, as hour and minute) and the interval.
Variations
Revenue potential
Tee times times four times the green fee. Compare it with actual daily revenue to get a utilization figure the GM will recognize.
Two tees (split-tee start)
A shotgun or split-tee morning doubles the sheet for the hours it runs. Compute each tee's window separately and add them.
Pitfalls & errors
Type the times as times, not text. 7:00 AM in a cell formatted as a time is a number; "7:00 AM" in a cell formatted as text is not, and subtracting it gives #VALUE!.
If the last tee time is after midnight for a lit range or night golf, add 1 to the difference: (C2-B2+1)*1440 when C2 is earlier than B2.
Do not forget the +1. 600 minutes at 9-minute intervals is 66 gaps but 67 tee times; leaving off the first slot under-counts every day by a foursome, which is a green fee times four.
Practice workbook
Frequently asked questions
Why 1440?
Should I count the last slot if the group cannot finish before dark?
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