Calculating hours

[Guest]

I have a problem and I don't know how to solve this issue.

I wan't to calculate hours for my employees with excel. I have problems when
hours exceed 40 hours and the hours aren't equal spread throughout the week.

Excel has to compensate days that someone did not work 8 hours until a total
of 40 hours. The extra hours will be booked as overtime

Example

Mo 9 has to be 9 (1 missing hour to compenstae Thursday)
Tu 8 has to be 8
We 12 has to be 10 (2 missing hours to compensate Thursday) and 1 hourovertime
Th 6 has to be 5
Fri 8 has to be 8

Can somebody help me?

Thank you very much!!

Greetings

H.J. Hagedoorn
Holland

 

[Peo Sjoblom]

Why don't you just sum all hours per week and then use anything that is
above 40 as OT?


--


Regards,


Peo Sjoblom




"Pagina-eind hyperlink probleem"

 

[Guest]

Thanks for your reaction!!

Because then I loose insight in the hours per day and in the end I want to
communicte with a larger database. Therefore I need the days seperated from
eachother

 

[Bob I]

Then leave the hours per day in the original location and simply
calculate overtime by subtracting 40 from the total.