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

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"
.com wrote in message
...
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

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

"Peo Sjoblom" wrote:

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"
.com wrote in message
...
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

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

Pagina-eind hyperlink probleem wrote:

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

"Peo Sjoblom" wrote:


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"
ft.com wrote in message
...

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