Counting hours each day with different values

A

AH

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 ?
 
B

Bob Phillips

What does the data look like?

Do you have a table of flat hours, and if so, where?
 
A

AH

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
 
Top