Time-Saving Metrics on Sorting By Color

[Henry Stockbridge]

Hi,

I am trying to find out whether metrics have been captured related to
the time saved by sorting Excl text or background by color. Has
anyone come across these numbers, and if so, what are they, or where
are they posted?

Thanks,

Henry

 

[Ryan H]

I'm not sure if there has been a study on that or not, but I would suggest if
you can't find anything, use this code below to time it and see for youself.

Sub TimeTest()

Dim StartTime As Single
Dim EndTime As Single
Dim RunTime As Single

StartTime = Timer

' run test sort code or color sort code here

EndTime = Timer

RunTime = EndTime - StartTime

MsgBox "RunTime = " & RunTime

End Sub

Hopefully this helps! If so, click "YES" below, Thanks!

 

[Henry Stockbridge]

I'm not sure if there has been a study on that or not, but I would suggest if
you can't find anything, use this code below to time it and see for youself.

Sub TimeTest()

Dim StartTime As Single
Dim EndTime As Single
Dim RunTime As Single

    StartTime = Timer

    ' run test sort code or color sort code here

    EndTime = Timer

    RunTime = EndTime - StartTime

    MsgBox "RunTime = " & RunTime

End Sub

Hopefully this helps!  If so, click "YES" below, Thanks!

Thanks, Ryan.