+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 19 of 19

Calculating Half Days in Attendance

  1. #16
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>>>Tamilnadu>>>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,344

    Re: Calculating Half Days in Attendance

    Using Exact()

    =SUM(SUMPRODUCT(--EXACT(C6:AG6,"p"))*0.5,COUNTIF(C6:AG6,"EL/P")*0.5,COUNTIF(C6:AG6,"P"))

    Or

    Using Find()

    =SUM(SUMPRODUCT(--ISNUMBER(FIND("p",C6:AG6)))*0.5,COUNTIF(C6:AG6,"EL/P")*0.5,COUNTIF(C6:AG6,"P"))


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  2. #17
    Registered User
    Join Date
    12-06-2018
    Location
    Toronto
    MS-Off Ver
    2013
    Posts
    4

    Re: Calculating Half Days in Attendance

    Hello,

    I know this thread is very old but it is the closest to my question.

    I am also keeping an attendance and I have to total for Sick days. I have two Total lines:
    1 Total line is recording the accumulated sick days: =COUNTIF(D9:D269,"S") and the other
    1. Total line is recording the accumulated half of days sick =COUNTIF(D9:D269,".5S")

    I want to only have one Total line, therefore, what formula do I have to use for the chart to add days in half days too? I tried =SUM(COUNTIFS(D9:D269,{"S",".5S"})) but this adds full days only.

    Thank you.
    Last edited by Felix_I; 12-06-2018 at 11:52 AM. Reason: Adding info

  3. #18
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,691

    Re: Calculating Half Days in Attendance

    Felix_I welcome to the forum

    Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.

  4. #19
    Registered User
    Join Date
    12-06-2018
    Location
    Toronto
    MS-Off Ver
    2013
    Posts
    4

    Re: Calculating Half Days in Attendance

    I apologize, I will start a new thread.

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

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

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