• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

time elapsed when data is entered between two cells

miming1986

New Member
upload_2017-3-18_21-19-16.png
Hi,
I would like Excel to measure the amount of time(in minutes) elapsed when data is entered between two cells( Columns B and E). I don't want previous time to update especially when they update values on columns B or anything that prevents them from manipulating the data. I just need to track how long they can process a certain order.

Thanks,
 
Last edited:
Miming

Firstly, Welcome to the Chandoo.org Forums

I'd suggest going to the main Chandoo.org web site
http://chandoo.org/wp/

Then use the Search Box at the Upper Right and search for Date Stamp or Time Stamp

There are a few posts and Forum entries on how to use them
 
@miming1986
One possible way ...
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
    ay = Target.Row
    Application.ScreenUpdating = False
    Application.EnableEvents = False
    With ActiveSheet
        Select Case Target.Column
            Case 2
                .Cells(1, 3000).ColumnWidth = 0
                If .Cells(ay, 1) <> Empty And .Cells(ay, 3000) = Empty Then .Cells(ay, 3000) = Now
            Case 5
                .Cells(1, 3001).ColumnWidth = 0
                If .Cells(ay, 3000) <> Empty And .Cells(ay, 3001) = Empty Then
                    .Cells(ay, 3001) = Now
                    .Cells(ay, 6) = Int((.Cells(ay, 3001) - .Cells(ay, 3000)) * 86400)
                End If
        End Select
    End With
    Application.EnableEvents = True
    Application.ScreenUpdating = True
End Sub
Copy it to any sheet's code sheet...
 
Back
Top