Time Keeper...
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Time Keeper...

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Central NY(not the park)
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi,
    I have a payroll worksheet with 7 columns (among others) representing the days of the week. Time values are totaled,SUM, in the 8th column, no problems. I need to track any of three others variables within the daily cells, these are "V" (Vacation),"P" (Personal),"H"(Holiday). Each of the three text have their own column. I am trying to write a formula to total only the text cells using an 8 hr format i.e if C3=8V and F3=8V then K3=16. Likewise if C4=8V and H4=8H then K4=8 and M4=8 and so on. I hope I haven't totaly confussed everyone. I also would like to add shading to these formulas if possible but will be satisfied to attempt that at a latter date.

    Help would be greatly appreciated, but I still just like to come here and read how you all help everyone else...

    Thanks...Scott

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,445
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Aloha Scott,
    I have a spreadsheet similar to yours. I have, as an example:
    Names in column A
    Work codes i.e. vac, sick etc. in column B
    Hours in column C

    =sumproduct($A$1:$A$50="name")*($B$1:$B$50="vac"),$C$1:$C$50)

    What this does is search for name and code, and if criteria is met, sum cells in column C

    Got this from Aladin!

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Central NY(not the park)
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Brian,
    Thanks for the reply. Will try it as soon as I can and let you know how it works.

  4. #4
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,445
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Forgot to tell you, it's an array formula, enter Ctrl+Shift+Enter

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com