While I had discovered this issue in the 1.0 release, I noticed that it is still in 1.5BETA. The function elapsedTime (shown below), appears to rounding the hours and minutes portions.
Original code:
elapsedTime = Format$(et / 3600000, "00") & ":" & _
Format$((et/ 60000) Mod 60, "00") & ":" & _<br/>
Format$((et/ 1000) Mod 60, "00")<br/>
Suggested revision:
elapsedTime = Format$(Fix( et / 3600000) , "00") & ":" & _
Format$( Fix( et/ 60000) , "00") & ":" & _<br/>
Format$((et/ 1000) Mod 60, "00")<br/>
to illustrate the issue I created a button with the following code:
Dim et As Double
Dim elapsedTime As String<br/>
Dim myVer As String<br/>
<br/>
' et = elapsedMilliseconds(stopNow)
et = Cdbl( Inputbox("Enter milliseconds to recalc:", "Millisecond conversion") )<br/>
elapsedTime = Format$(et / 3600000, "00") & ":" & _<br/>
Format$((et/ 60000) Mod 60, "00") & ":" & _<br/>
Format$((et/ 1000) Mod 60, "00")<br/>
<br/>
elapsedTime2 = Format$(Fix( et / 3600000) , "00") & ":" & _<br/>
Format$( Fix( et/ 60000) , "00") & ":" & _<br/>
Format$((et/ 1000) Mod 60, "00")<br/>
<br/>
<br/>
Msgbox "Millisecs: " & et & Chr$(10) & _<br/>
"Orig conver: " & elapsedTime & Chr$(10) & _<br/>
"Suggested version: " & elapsedTime2<br/>
Enter in 1893000 milliseconds.