Formula for times

  • Thread starter Thread starter Travis
  • Start date Start date
T

Travis

I need to make a list of times using different perameters
to come up with the times. I need to be able to set a
starting time(7:30), the number of times I need to have
the time repeated (3-4),and the gap between times(6-12
Minutes). This is going to be used to assign tee times
for a golf tournament. Also, I need to be able to set
the number of sides that the players start on(1-2). Any
suggestions would be greatly apreciated.
 
Hi Travis!

A1: Starting Time B1: 07:30
A2: Repeat B2: 4
A3: Time Gap B3: 0:06

A5:
=B1
A6:
=IF(MOD(ROW(A5)-ROW($A$4),$B$2)=0,A5+$B$3,A5)
Format as time
Copy down

I don't understand the second question as I'm not in the habit of spoiling a
good walk.
--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top