View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Peter T[_7_] Peter T[_7_] is offline
external usenet poster
 
Posts: 162
Default Efficient standard to military time

"Robert Crandal" wrote in message

Nice alternative solution. I wonder if this will be faster than
the previous solution?


I did test before posting (because you said speed was important) and found
my alternative was about twice as fast as the RegExp, and that was
maintaining and reusing the RegExp object. That said if only calling a few
times the difference would be negligible. However when not reusing but
recreating the RegExp object each time it was tens of times faster, as
expected.

Regards,
Peter T