Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help on select case
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select case | Excel Discussion (Misc queries) | |||
Case without Select Case error problem | Excel Discussion (Misc queries) | |||
Select Case | Excel Discussion (Misc queries) | |||
Need help on Select Case | Excel Worksheet Functions | |||
select case help please | Excel Programming |