Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating hours
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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200801/1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating hours
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" <u41001@uwe wrote in message news:7efbeb21b2c5c@uwe... 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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200801/1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating hours
Hi
What format should the date be and should they be in the same cell for from and to? Kelly Fred Smith wrote: 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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200801/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating hours with custom [t]:mm:ss | Excel Discussion (Misc queries) | |||
Calculating hours | Excel Discussion (Misc queries) | |||
Calculating hours | Excel Worksheet Functions | |||
calculating hours | Excel Worksheet Functions | |||
Calculating working hours | Excel Discussion (Misc queries) |