Thread: Timer
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 380
Default Timer

Use Format(nTime,0) in the time display.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Steve" wrote in message
...
Just a quick question.

I found how to doa timer by search on here which works really well.

However, can't seem to format it so it only says "7 seconds" as opposed to
"7.123456 seconds"

Any help would be appreciated.

Thanks
--
Steve R