Uzytkownik "Paul Black" napisal w
wiadomosci ...
Hi Everyone,

I have this Bit of Code that Outputs the Total Processing Time of a
Macro .

Active.Offset(1, 0) = "Processing Time " & _
Format(((Timer - Start) / 24 / 60 / 60), "hh:mm:ss")

. in the Format 00:09:36 which Works Great.
What I would like is for it to Output with the Words Hours, Minutes and
Seconds .

00 Hours 09 Minutes 36 Seconds.
I have Tried Using the "&" and Text But to No Avail.

Any Help will be Appreciated.
Thanks in Advance.
Paul



*** Sent via Developersdex http://www.developersdex.com ***


you can try to format cell like
hh" hours":mm" minurtes":ss" seconds"
mcg