What do you mean by running time. please share more examples.
On Wed, May 23, 2012 at 9:17 AM, PRAVESH KUMAR wrote:
> Hi Group,
>
> please tell How to create running time in excel sheet??
> --
>
>
> *Thanks & Regards*
>
> *Pravesh Kumar*
>
> --
> FORUM RULES (986+ members already BANNED for viola
Nice Rajan.
On Wed, May 23, 2012 at 12:01 PM, Rajan_Verma wrote:
> See the attached File
>
>
> Sub RunningTime()
> Range("A1").Value = Format(Now, " dd-mm-yy hh:mm:ss")
> Application.OnTime Now + TimeSerial(0, 0, 1), "RunningTime"
> End Sub
>
> Sub EndTime()
> On Error Resume Next
> Applicati
See the attached File
Sub RunningTime()
Range("A1").Value = Format(Now, " dd-mm-yy hh:mm:ss")
Application.OnTime Now + TimeSerial(0, 0, 1), "RunningTime"
End Sub
Sub EndTime()
On Error Resume Next
Application.OnTime Now + TimeSerial(0, 0, 1), "RunningTime", Schedule:=False
End Sub
Regard
