Time

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?
 
J

Joe Lewis

In the "start" cell type:

CTRL + SHIFT + ;

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

Joe
 
S

Satti Charvak

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

Bob I

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
 
Top