Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello everyone,
I would like to display automatically a daily work planning. The person could simply input their in (arrival time) and out (departure time) in(out of) the office everyday. The person can work everyday: from monday to sunday, and can begin at any time during the day or during the night. Therefore, there are 4 categories: Categ(100%): from 07:00 to 19:00 Categ(125%): from 19:00 to 07:00 (if the number of hours per day is less than 8). Categ(150%): the same as categ(125%) but for a number of hours greater than 8h per day. Categ(200%): during the weekend, 24h/24 Question: I would like, that, when the person arrives or leaves their office, when entering their IN and OUT (time) every day, the above 4 colons, will be filled in automatically indicating the number of hours (per day) at 100%, at 125%, at 150% and at 200%. Thanks very much for helping me. Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with program planning | Excel Discussion (Misc queries) | |||
financial planning | Excel Discussion (Misc queries) | |||
Material Requirements Planning-MRP/Capacity Requirements Planning- | Excel Discussion (Misc queries) | |||
Planning reports | Excel Discussion (Misc queries) | |||
Planning system | Excel Programming |