Thread
:
help on select case
View Single Post
#
2
Posted to microsoft.public.excel.programming
Frank Kabel
external usenet poster
Posts: 3,885
help on select case
Hi
there is no such build-in functionality but you may have a look at
http://j-walk.com/ss/excel/files/timesht.htm
to see an example workbook for time tracking
--
Regards
Frank Kabel
Frankfurt, Germany
wrote:
we are Emmaus guys. You know ? We receive a brand new PC with Excel.
Now we need some help. What we want is a timing schedule for our job.
We think somethin like a single sheet for each of us with 6 columns
column 1 : the day date
column 2 : the time of arrival in the morning
column 3 : the lunch time departure
column 4 : the lunch time return
column 5 : the night time leaving
column 6 : total of daily working hours
we heard about one button which could insert all those informations
when ckicked (they say select case !!!)
Have no more idea than
1st click : the day and arrival time is inserted
2nd click : the lunch time departure is inserted
3rd click : the lunch return time is...
4th click : the departure time is ... and the daily hours are
calculated
the day after a new row is open for the same details and by the end
of
the month we could got the total for each of our people.
Is that right ?
Many thank for all informations
Joseph/Leman Lake
Reply With Quote
Frank Kabel
View Public Profile
Find all posts by Frank Kabel