|Have you considered using a commercially available "pool hall management" software package? I did a quick Google search and found a few products, one for under $400. These packages have features like waiting lists, table usage data, food order tracking, and even the ability to control the lights over the tables.|
As far as Excel goes, you will need a macro to add the time based on the input of a table number. Excel has a feature known as Event Macros which run when a specific event occurs.
For the Start Time, you can use the Worksheet_Change event which will run whenever a change is made to the sheet. The first thing it will do is check to see in which Column the change was made and if it matches the specified conditions (1 cell changed in Column B) then it will proceed with the rest of the instructions - e.g. put the time in Column C.
For the Finish Time, you can use the Worksheet_BeforeDoubleClick event so that the user simply has to double click a cell in Column D to insert the time.
Right click the sheet tab for the sheet you want this to happen in and choose View Code.
Paste the following code into the pane that opens. When a value is entered in a cell in Column B, the corresponding cell in Column C will display the current time.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 And Target.Cells.Count = 1 Then
Range("C" & Target.Row) = Time
For the Finish Time, paste this code in the same pane. When the user double clicks a cell in Column D, the current time will be entered.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column = 4 Then Target = Time
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.