Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calendar, if paid on date, not count prior
I'm trying to track time spent on a monthly calendar in excel. I need to
create function to total the hours each week and then those are totaled by month. If the hours are paid on wednesday, is there a way to not calculate the hours for monday and tuesday? This is probably more work to setup than will save me time, but now that the question is in my head I need to know if it's possible. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calendar, if paid on date, not count prior
Its possible. Without knowing exactly how your formulas are setup, my help is
limited, but I would suggest looking at the WEEKDAY function for a way to determine if a date is Monday or Tuesday. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jake F" wrote: I'm trying to track time spent on a monthly calendar in excel. I need to create function to total the hours each week and then those are totaled by month. If the hours are paid on wednesday, is there a way to not calculate the hours for monday and tuesday? This is probably more work to setup than will save me time, but now that the question is in my head I need to know if it's possible. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calendar, if paid on date, not count prior
Hi Jake
Presumably those hours are going to have to be counted as part of the next pay period.. I think the easiest way would be to enter into 2 cells the earliest date you want to pay and latest date you want to pay. Then =SUMPRODUCT((Dates=Earliest)*(Dates<=Latest)*Hour s) will give the answer. Substitute the cell ranges for Dates and Hours and the cells where you have entered Earliest and Latest. -- Regards Roger Govier "Jake F" wrote in message ... I'm trying to track time spent on a monthly calendar in excel. I need to create function to total the hours each week and then those are totaled by month. If the hours are paid on wednesday, is there a way to not calculate the hours for monday and tuesday? This is probably more work to setup than will save me time, but now that the question is in my head I need to know if it's possible. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide data points prior to a certain date | Charts and Charting in Excel | |||
Dates - Need to display date one month prior to user-entered date | Excel Worksheet Functions | |||
calculate prior calendar year end from a moving current date | Excel Worksheet Functions | |||
Multiple IFs prior to Count function | Excel Worksheet Functions | |||
Validate date within range prior to calculation | Excel Discussion (Misc queries) |