| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting hours each day with different values
Hi
I have a list of all days in a one week. (man....sun) Employes start at different times each day. Example: Manday from 05.30 am - 08.30 pm Sunday from 05.00 am - 09.00 pm Hours from is payd flat from 0600 am - 1900 pm From 00.00 am - 06.00 am each ours is payd with 20 % moore and from 07.00 pm - 00.00 pm with 15 % moore I will make list of one week. How can i make a overview how many 20 % and 15 % hour it is in one week ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting hours each day with different values
What does the data look like?
Do you have a table of flat hours, and if so, where? -- __________________________________ HTH Bob "AH" wrote in message ... Hi I have a list of all days in a one week. (man....sun) Employes start at different times each day. Example: Manday from 05.30 am - 08.30 pm Sunday from 05.00 am - 09.00 pm Hours from is payd flat from 0600 am - 1900 pm From 00.00 am - 06.00 am each ours is payd with 20 % moore and from 07.00 pm - 00.00 pm with 15 % moore I will make list of one week. How can i make a overview how many 20 % and 15 % hour it is in one week ? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting hours each day with different values
Hi All data is in excel - same sheet a1 a2 a3 a4(count 15% hours) a5 (Count20%) monday 05.00 - 21.20 (norwegian) macro macro tuesday 04.00 - 22.00 macro macro "Bob Phillips" wrote: What does the data look like? Do you have a table of flat hours, and if so, where? -- __________________________________ HTH Bob "AH" wrote in message ... Hi I have a list of all days in a one week. (man....sun) Employes start at different times each day. Example: Manday from 05.30 am - 08.30 pm Sunday from 05.00 am - 09.00 pm Hours from is payd flat from 0600 am - 1900 pm From 00.00 am - 06.00 am each ours is payd with 20 % moore and from 07.00 pm - 00.00 pm with 15 % moore I will make list of one week. How can i make a overview how many 20 % and 15 % hour it is in one week ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting hours | Excel Discussion (Misc queries) | |||
| Counting DD:HH:MM NETWORKDAYS and Hours | Excel Worksheet Functions | |||
| Date (hours and still counting) | Excel Worksheet Functions | |||
| Counting hours | Excel Programming | |||
| Counting Occurences of Hours of the Day | Excel Discussion (Misc queries) | |||
Hybrid Mode
