Rajan
only commented the work I've done
1 .- move the cursor and enter hours
2 .- hours Clickleft button entry
3 .- add ins stopwatch to determine differences
4 .- formulated to test differences
Atte
Chilexcel
2012/6/19 Suman
> Thanks a lot rajan jee..!
>
> --
>
>
>
>
>
>
>
>
>
> *Su
Thanks a lot rajan jee..!
--
*Suman Kumar*
On Tue, Jun 19, 2012 at 4:21 PM, Rajan_Verma wrote:
> Hi
>
> In workbook code module Paste this :
>
>
> Private Sub Workbook_BeforeClose(Cancel As Boolean)
> StopIt
> End Sub
>
> Private Sub Workbook_Open()
>GetStart
> End Sub
>
> i
nice
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ChilExcel
Sent: 19 June 2012 9:09
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: How to creat digital watch
Rajan ..
I created an add ins to add to the clock
its purpose is to determine the timecode breaks
talk about its usefulness
example
Stat End time difference
21:49:23,66 21:49:28,61 00:00:04,95
Chilexcel
2012/6/19 Rajan_Verma :
Hi
In workbook code module Paste this :
Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopIt
End Sub
Private Sub Workbook_Open()
GetStart
End Sub
in Standart Module paste this:
Sub GetStart()
Range("A1").Value = Format(Now, "HH:MM:SS")
Application.OnTime Now + Tim
