I would like to be able to click on a cell then click on a clock to enter my
start and end times, i.e.
start time: click in a cell, then on clock icon or button: 9:00 AM,
end time: click in a cell, then on clock icon or button: 10:00 AM
time worked: click in a cell to get the tme worked: 1:00

Excel has a built-in time clock. Click on a cell and touch CNTRL-SHFT-;
--
Gary''s Student - gsnu201001


"LiseF" wrote:

I would like to be able to click on a cell then click on a clock to enter my
start and end times, i.e.
start time: click in a cell, then on clock icon or button: 9:00 AM,
end time: click in a cell, then on clock icon or button: 10:00 AM
time worked: click in a cell to get the tme worked: 1:00

I already know this....I would like to have an actual clock as I asked in my
question.


"Gary''s Student" wrote:

Excel has a built-in time clock. Click on a cell and touch CNTRL-SHFT-;
--
Gary''s Student - gsnu201001


"LiseF" wrote:

I would like to be able to click on a cell then click on a clock to enter my
start and end times, i.e.
start time: click in a cell, then on clock icon or button: 9:00 AM,
end time: click in a cell, then on clock icon or button: 10:00 AM
time worked: click in a cell to get the tme worked: 1:00

You could make a button (from the forms menu) link to this macro:

Sub TimeStamp()
ActiveCell.Value = Format(Now, "h:mm AM/PM")
End Sub

For the last cell, that would be a simple formula, no need to click
anything. Something like:
=IF(COUNT(A2:A3)=2,A3-A2,"")


--
Best Regards,

Luke M
"LiseF" wrote in message
...
I already know this....I would like to have an actual clock as I asked in
my
question.


"Gary''s Student" wrote:

Excel has a built-in time clock. Click on a cell and touch CNTRL-SHFT-;
--
Gary''s Student - gsnu201001


"LiseF" wrote:

I would like to be able to click on a cell then click on a clock to
enter my
start and end times, i.e.
start time: click in a cell, then on clock icon or button: 9:00 AM,
end time: click in a cell, then on clock icon or button: 10:00 AM
time worked: click in a cell to get the tme worked: 1:00

In that case,see:

http://www.dailydoseofexcel.com/arch...3/time-picker/
--
Gary''s Student - gsnu201001


"LiseF" wrote:

I already know this....I would like to have an actual clock as I asked in my
question.


"Gary''s Student" wrote:

Excel has a built-in time clock. Click on a cell and touch CNTRL-SHFT-;
--
Gary''s Student - gsnu201001


"LiseF" wrote:

I would like to be able to click on a cell then click on a clock to enter my
start and end times, i.e.
start time: click in a cell, then on clock icon or button: 9:00 AM,
end time: click in a cell, then on clock icon or button: 10:00 AM
time worked: click in a cell to get the tme worked: 1:00