Results 1 to 4 of 4

Add Data for Full and Partial week

Threaded View

rizmomin Add Data for Full and Partial... 07-29-2013, 03:23 PM
wfm007 Re: Add Data for Full and... 07-29-2013, 03:46 PM
daffodil11 Re: Add Data for Full and... 07-29-2013, 03:48 PM
rizmomin Re: Add Data for Full and... 07-29-2013, 04:20 PM
  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Add Data for Full and Partial week

    Hello:

    Please refer to attached excel file.

    Row 2 (cell M2) onwards shows day of the week.
    I need to add hours for each employee for partial and full week.
    Week starts from Monday and ends on Sunday.
    Hence I have manually added partial week data in column M and N in Cell G3:G13 and full week data in Column O thru U in cell H3:H13

    I need a formula to do this automatically.

    Please let me know if any questions.

    Thank you

    Riz Momin
    Attached Files Attached Files
    Last edited by rizmomin; 07-29-2013 at 04:20 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 06-08-2013, 01:52 PM
  2. remove a data point in the chart if it's not a full week’s data
    By seatejo in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-16-2013, 04:05 AM
  3. macro to offset payments against invoices (full and partial)
    By bwaite87 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-27-2013, 10:55 AM
  4. Formula needed to return values for partial or full match
    By IntRes in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-07-2012, 08:32 AM
  5. Determining Whether a Person Worked a Full or Partial Shift
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-23-2005, 12:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1