P
Paul Black
Hi Everyone,
I have a Macro that I want to Time.
I have Added at the Beginning …
Dim Start As Double
Start = Timer
… and at the End Before the End Sub …
ActiveCell.Offset(8, 0) = Format(Timer - Start, "0.00") / 60 & "
Minutes"
Why Does it Give me More Decimal Places than I have Specified?.
Ideally, I would like it to Show in Hours, Minutes and Seconds,
Something Like 00.00.00.
Any Help will be Appreciated.
All the Best
Paul
I have a Macro that I want to Time.
I have Added at the Beginning …
Dim Start As Double
Start = Timer
… and at the End Before the End Sub …
ActiveCell.Offset(8, 0) = Format(Timer - Start, "0.00") / 60 & "
Minutes"
Why Does it Give me More Decimal Places than I have Specified?.
Ideally, I would like it to Show in Hours, Minutes and Seconds,
Something Like 00.00.00.
Any Help will be Appreciated.
All the Best
Paul