Calculating hours

[Kelly_Durden via OfficeKB.com]

Hello

Is there a formula to calculate the following by month>

Consultant services 7th Jan 2008 – 30th June 2008 Max 40 hours/week £90 per
hour

Thanks in advance
Kelly

 

[Fred Smith]

The formula depends on the assumptions you want to make.

You say max 40 hours/week. How do you tell if you worked less than 40 hours
in a week? What about partial weeks? Are they prorated? Are you paid for
holidays during the period?

The likely solution is to calculate the number of working days in the period
using NETWORKDAYS, multiply by hours per day times the rate.

If that's not enough to go on, post back with the required assumption
answers.

Regards
Fred

 

[Kelly_Durden via OfficeKB.com]

Hi

What format should the date be and should they be in the same cell for from
and to?

Kelly

The formula depends on the assumptions you want to make.

You say max 40 hours/week. How do you tell if you worked less than 40 hours
in a week? What about partial weeks? Are they prorated? Are you paid for
holidays during the period?

The likely solution is to calculate the number of working days in the period
using NETWORKDAYS, multiply by hours per day times the rate.

If that's not enough to go on, post back with the required assumption
answers.

Regards
Fred

Hello

[quoted text clipped - 6 lines]

Thanks in advance
Kelly