LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide data points prior to a certain date Rachel Garrett Charts and Charting in Excel 1 May 8th 08 10:44 PM
Dates - Need to display date one month prior to user-entered date brettopp Excel Worksheet Functions 13 December 3rd 07 05:58 PM
calculate prior calendar year end from a moving current date Louise Excel Worksheet Functions 1 December 6th 06 08:48 PM
Multiple IFs prior to Count function Excel novice Excel Worksheet Functions 3 May 12th 06 11:42 AM
Validate date within range prior to calculation Natassja Excel Discussion (Misc queries) 1 January 24th 06 05:52 PM


All times are GMT +1. The time now is 04:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"