|
List Info
Thread: Time in and out
|
|
| Time in and out |
|
2006-10-30 10:03:56 |
Apologies! I have been using this for so long that I forgot
the first use
problems. In H1 & I 1 enter "IN" &
"OUT";
in H4 & I4 enter 8:55; in H5 & I5 enter a dummy time
- I suggest 1. Hide
rows 2 to 5.
Also - These macros I run from buttons not the keyboard. I
suggest that you
modify the keyboard shortcuts to make them uppercase. Ctrl
+ o brings uo
the "Open files" dialogue.
On 27/10/06, Admin <Admin shadeyco.co.uk> wrote:
>
> On 27 Oct 2006 at 15:02, Adrian Fielden wrote:
>
> >Yes. Puts the new time into the first empty cell in
that column.
>
> Not on my PC it goes to 65536 then tries to go one more
?
>
> >expression.Offset(RowOffset, ColumnOffset)
> >
> >expression Required. An expression that returns a
Range object.
> >
> >RowOffset Optional Variant. The number of rows
(positive, negative, or
> 0
> >(zero)) by which the range is to be offset.
Positive values are offset
> >downward, and negative values are offset upward.
The default value is 0.
>
>
>
> >On 27/10/06, Admin <Adminshadeyco.co.uk> wrote:
> >>
> >> On 27 Oct 2006 at 13:02, Adrian Fielden wrote:
> >>
> >> >Hi
> >> >
> >> >There was recently a query about recording
times in and out. By clumsy
> >> >mistake I foolishly deleted the
conversation. My apologies to the
> >> >originator. For what it is worth here is
the reply I would have sent.
> >>
> >> Not sure I follow the code compleatly but this
(these) line errors
> >> out the whole thing in both SUB()'s
> >>
> >> > Selection.End(xlDown).Select
> >> > ActiveCell.Offset(1, 0).Select
> >>
> >> last cell in Column then one more ?
> >>
> >>
>
------------------------------------------------------------
--------------
> >> The EXCEL-G list is hosted on a Windows NT(TM)
machine running L-Soft
> >> international's LISTSERV(R) software. For
subscription/signoff info
> >> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
> >> COPYRIGHT INFO:
> >> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
> >>
> >
> >
> >
> >--
> >Regards
> >
> >Adrian Fielden
> >
>
>
>--------------------------------------------------------
------------------
> >The EXCEL-G list is hosted on a Windows NT(TM)
machine running L-Soft
> >international's LISTSERV(R) software. For
subscription/signoff info
> >and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
> > COPYRIGHT INFO:
> >http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
> >
>
>
------------------------------------------------------------
--------------
> The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
> international's LISTSERV(R) software. For
subscription/signoff info
> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
> COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
>
--
Regards
Adrian Fielden
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|
|
| Time in and out |
|
2006-10-30 16:45:32 |
On 30 Oct 2006 at 10:03, Adrian Fielden wrote:
>Apologies! I have been using this for so long that I
forgot the first use
>problems. In H1 & I 1 enter "IN" &
"OUT";
>in H4 & I4 enter 8:55; in H5 & I5 enter a dummy
time - I suggest 1. Hide
>rows 2 to 5.
>Also - These macros I run from buttons not the keyboard.
I suggest that you
>modify the keyboard shortcuts to make them uppercase.
Ctrl + o brings uo
>the "Open files" dialogue.
That seems to work now
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
behaves
one query now what do/should the formula in P871 & R871
do ? or more
why so far down
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|
|
| Time in and out |
|
2006-10-30 16:45:32 |
On 30 Oct 2006 at 10:03, Adrian Fielden wrote:
>Apologies! I have been using this for so long that I
forgot the first use
>problems. In H1 & I 1 enter "IN" &
"OUT";
>in H4 & I4 enter 8:55; in H5 & I5 enter a dummy
time - I suggest 1. Hide
>rows 2 to 5.
>Also - These macros I run from buttons not the keyboard.
I suggest that you
>modify the keyboard shortcuts to make them uppercase.
Ctrl + o brings uo
>the "Open files" dialogue.
That seems to work now
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
behaves
one query now what do/should the formula in P871 & R871
do ? or more
why so far down
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|
|
| Time in and out |
|
2006-10-31 14:29:36 |
I can't see R871 used but P871 calculates the hours worked
in decimal and
N871 converts it to h:mm format (as I said earlier this was
one of my early
attempts and I would do it in one step now). The reason that
they are so far
down is that the workbook was started in January 2005 and I
have had so many
entrances and exits since then.
The workbook as a whole is an detailed control of my use of
a flexitime
system and the macros shown are the core, but only a small
part, of the
syatem.
On 30/10/06, Admin <Adminshadeyco.co.uk> wrote:
>
> On 30 Oct 2006 at 10:03, Adrian Fielden wrote:
>
> >Apologies! I have been using this for so long that
I forgot the first use
> >problems. In H1 & I 1 enter "IN"
& "OUT";
> >in H4 & I4 enter 8:55; in H5 & I5 enter a
dummy time - I suggest 1. Hide
> >rows 2 to 5.
>
> >Also - These macros I run from buttons not the
keyboard. I suggest that
> you
> >modify the keyboard shortcuts to make them
uppercase. Ctrl + o brings uo
> >the "Open files" dialogue.
>
> That seems to work now
>
> Selection.End(xlDown).Select
> ActiveCell.Offset(1, 0).Select
>
> behaves
>
> one query now what do/should the formula in P871 &
R871 do ? or more
> why so far down
>
>
------------------------------------------------------------
--------------
> The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
> international's LISTSERV(R) software. For
subscription/signoff info
> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
> COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
>
--
Regards
Adrian Fielden
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|
|
| Time in and out |
|
2006-10-31 14:29:36 |
I can't see R871 used but P871 calculates the hours worked
in decimal and
N871 converts it to h:mm format (as I said earlier this was
one of my early
attempts and I would do it in one step now). The reason that
they are so far
down is that the workbook was started in January 2005 and I
have had so many
entrances and exits since then.
The workbook as a whole is an detailed control of my use of
a flexitime
system and the macros shown are the core, but only a small
part, of the
syatem.
On 30/10/06, Admin <Adminshadeyco.co.uk> wrote:
>
> On 30 Oct 2006 at 10:03, Adrian Fielden wrote:
>
> >Apologies! I have been using this for so long that
I forgot the first use
> >problems. In H1 & I 1 enter "IN"
& "OUT";
> >in H4 & I4 enter 8:55; in H5 & I5 enter a
dummy time - I suggest 1. Hide
> >rows 2 to 5.
>
> >Also - These macros I run from buttons not the
keyboard. I suggest that
> you
> >modify the keyboard shortcuts to make them
uppercase. Ctrl + o brings uo
> >the "Open files" dialogue.
>
> That seems to work now
>
> Selection.End(xlDown).Select
> ActiveCell.Offset(1, 0).Select
>
> behaves
>
> one query now what do/should the formula in P871 &
R871 do ? or more
> why so far down
>
>
------------------------------------------------------------
--------------
> The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
> international's LISTSERV(R) software. For
subscription/signoff info
> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
> COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
>
--
Regards
Adrian Fielden
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|
|
| Time in and out |
|
2006-10-31 16:33:10 |
On 31 Oct 2006 at 14:29, Adrian Fielden wrote:
Sorry my typo
It was jsust odd "coming in late" as it were to
have formula in Rows
1-5 & 871 I guess that over time you have moved the last
two formul
down a bit at a time
>I can't see R871 used but P871 calculates the hours
worked in decimal and
>N871 converts it to h:mm format (as I said earlier this
was one of my early
>attempts and I would do it in one step now). The reason
that they are so far
>down is that the workbook was started in January 2005
and I have had so many
>entrances and exits since then.
>The workbook as a whole is an detailed control of my use
of a flexitime
>system and the macros shown are the core, but only a
small part, of the
>syatem.
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|
|
[1-6]
|
|
|
about | contact Other archives ( Real Estate discussion Medical topics )
|