Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating b-weekly pay
I have a worksheet that calculates daily earnings based on number of
hours worked each day (hrs x rate). Each day worked is inputed in a separate row. There is an irregular number of days worked per period. What formula can I use to calculate a bi-weekly pay based on calendar days inputed in each period, in such a way that I don't have to manually adjust range of rows included in the calculation? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating b-weekly pay
First make a column of pay periods. Assume the first period is Monday Jan 1
thru Sunday Jan 14, etc. Lets say your dates are in column A and you daily dollar totals are in column B. In an un-used column, say column G, enter: =ROUNDDOWN((A1-39083)/14+1,0) Format this as General and copy all the way down. Then make a Pivot Table from columns B&G. See: http://peltiertech.com/Excel/Pivots/pivottables.htm -- Gary's Student gsnu200704 "xaveryptak" wrote: I have a worksheet that calculates daily earnings based on number of hours worked each day (hrs x rate). Each day worked is inputed in a separate row. There is an irregular number of days worked per period. What formula can I use to calculate a bi-weekly pay based on calendar days inputed in each period, in such a way that I don't have to manually adjust range of rows included in the calculation? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating b-weekly pay
With the daily date in Column A and the daily earnings in Column F try:
=SUMPRODUCT((A1:A1000=Start Date)*(A1:A1000<=End Date)*F1:F1000) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "xaveryptak" wrote in message ups.com... I have a worksheet that calculates daily earnings based on number of hours worked each day (hrs x rate). Each day worked is inputed in a separate row. There is an irregular number of days worked per period. What formula can I use to calculate a bi-weekly pay based on calendar days inputed in each period, in such a way that I don't have to manually adjust range of rows included in the calculation? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating daily hours (as text) in the weekly total formula | Excel Worksheet Functions | |||
Need help with formula for Weekly Value | Excel Worksheet Functions | |||
Problem calculating weekly costs | Excel Worksheet Functions | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) |