BBO Discussion Forums: Using Excel to calculate Start times - BBO Discussion Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Using Excel to calculate Start times

#1 User is offline   inquiry 

  • PipPipPipPipPipPipPipPipPipPip
  • Group: Admin
  • Posts: 14,566
  • Joined: 2003-February-13
  • Gender:Male
  • Location:Amelia Island, FL
  • Interests:Bridge, what else?

Posted 2006-April-09, 20:56

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.
--Ben--

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users