Time

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I would like to click in a cell and have the hh:mm:ss populate that cell. I
am timing how long it takes for water to drop two inches. So I have a start
time, a middle time (1st inch) and an end time (2nd inch). Then I need to
calculate the elapsed time from the middle to the end and have that
difference dispalyed in a fourth cell.

Help? Please? Pretty Please?
 
In the "start" cell type:

CTRL + SHIFT + ;

to insert the current time. Repeat for the mid and end cells.

Joe
 
add a button on the excel sheet

use this macro function

Sub Button1_Click()
If Len(Cells(1, 1).Value) > 0 Then
If Len(Cells(1, 2).Value) > 0 Then
Cells(1, 3).Value = Now()
Cells(1, 5).Value = "=C1-B1"
Else
Cells(1, 2).Value = Now()
End If
Else
Cells(1, 1).Value = Now()
End If
End Sub

this is a crude example, please purify this as per you requirements.

note that in the cells function, first paramenter is the row number and the
second parameter is the column number.
 
Gravity says that the drop of water will fall 16 feet in the first
second. You will need resolution to thousanths of a second, so you
really need not bother with hh:mm:ss
 
Back
Top