View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ah ah is offline
external usenet poster
 
Posts: 33
Default 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 ?