how can i record how long a workbook is open?
 

Try this :

Private Sub Workbook_Open()
' This will log the Time Opened
With Sheet1
..Range("A1").Value = Now()
End With
End Sub


Private Sub Workbook_BeforeClose(Cancel As Boolean)
' This will Log the Time Closed and the Time WorkBook was opened in A3.
With Sheet1
..Range("A2").Value = Now()
..Range("A3").Value = .Range("A2").Value - Range("A1").Value
End With
MsgBox "This workBook was just Opened for " & Range("A3").Text
End Sub


Format A1-A3 as hhmmss


Corey....


If you set say A3 to Compare the difference in time difference in time would
be how long the workbook was last used for

"AJB" wrote in message
...
I am trying to roughly track time spent on our estimating process. Thanks!