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?

Tom

Start A1
Mid B1
End C1

Did you try C1-B1

Mike

"Tom" wrote:

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




"Tom" wrote:

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?

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.



--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"Tom" wrote:

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?

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

Tom wrote:

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?