While Excel can display time in ms, ("[h]:mm:ss.000",) Neither the Bet Angel Sheet, last update time cell nor the Update Times log we got from CPerry recorded Time in less than whole seconds.If Betangel give an accurate update time with an accuracy of at least 10 ms
Developer Note: http://betangel.kayako.com/Knowledge...-practice-mode
http://betangel.kayako.com/Knowledge...tions-settings
"The expected response times inside the UK can be anywhere between 50ms - 200ms."
End Note
Maybe something like:
BA Cell C3 = LastUpdateTime
clsUpdatesPerSecondSub Worksheet_Change If Target = C3 then UpdatePerSecond.Tik = C3 ' ' ' End Sub
Dim LastSecond As Date Dim CurrentSecond As Date Dim TikCount As Long Dim Tik As Date Dim PreviousValue As Double Private pValue As Double Property Let Tik(UpdateTime As Date) CurrentSecond = UpdateTime If CurrentSecond = LastSecond Then TikCount = TikCount + 1 Else LastSecond = UpdateTime End If CalculateValue End Property Private Sub CalculateValue If CurrentSecond = LastSecond Then PreviousValue = 1000 /TikCount 'ms per update in this second Else pValue = PreviousValue 'ms per update in last whole second 'Reset times and counts TikCount = 0 LastSecond = CurrentSecond End Sub Property Get Value() 'Used as Modifier for Certain Formulas per otl Value = FunctionBytOffTheLip(pValue) End Property




Reply With Quote
