SELECT div.division,
       DEP.department,
       DEP.strength,
       E.employeecode,
       E.name,
       DES.designation,
       E.shift,
       I.idate,
       To_char(Min(I.intime), 'HH:MI AM'),
       To_char(Max(I.outtime), 'HH:MI AM'),
       Round(SUM(I.btime) / 60)
FROM   hrm_employees E,
       hrm_department DEP,
       hrm_designation DES,
       hrm_inout I,
       hrm_division div
WHERE  E.employeecode = I.employeecode(+)
       AND DEP.departmentcode = E.departmentcode
       AND DES.designationcode = E.designationcode(+)
       AND div.divisioncode = e.divisioncode
       AND ( div.divisioncode = :p_divcode
              OR :p_divcode IS NULL )
       AND ( I.idate(+) BETWEEN :from_date AND :to_date )
GROUP  BY div.division,
          DEP.department,
          E.employeecode,
          E.name,
          DES.designation,
          I.idate,
          e.shift,
          DEP.strength
ORDER  BY E.employeecode,
          dep.department; 

function ... return number
is
  retval number;
begin
  select count(*)
    into retval
    from your_table
    where intime is not null;

  return (retval);
end;

FUNCTION Cf_presentformula
RETURN NUMBER
IS
  v_present NUMBER;
BEGIN
    SELECT Count(1)
    INTO   v_present
    FROM   hrm_employees E,
           hrm_department D,
           hrm_inout I
    WHERE  D.departmentcode = E.departmentcode
           AND E.employeecode = I.employeecode
           AND I.employeecode = :EMPLOYEECODE
           AND E.employeecode = :EMPLOYEECODE
           AND D.department = :DEPARTMENT
           AND I.intime IS NOT NULL;

    RETURN v_present;
EXCEPTION
  WHEN OTHERS THEN
             RETURN NULL;
END;