Excel's time functions can be used to simplify calculating tourney start times.
You need the Now function @Now()
The date and time of the tourney in a cell format to the date in the formatted as:
3/14/98 1:30 PM
Then three cells that extract days, hours, and minutes from the cell with the time/date in it. Assume Cell B5 has the time of the tourney and C2 has the now funtion, then.... C5 could be:
=if(hour(c$2)>hour(B4),DAYS360(C$2,B5-1),Days360(C$2,B5))
Then D5 could be, which returns hours to start
=+hour(B5-C$2+C5)
Then E5 could be, which returns min until start
=Minute(B5-C$2+C5)
You can then copy cells C5 to E5 into c6, c7, etc, then add more days. Also you can do day math on the dates in the B column.
Page 1 of 1
Using Excel to calculate Start times
Page 1 of 1