1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

BG Absence Formula

Discussion in 'Oracle HRMS & Payroll' started by Badawy, Nov 12, 2012.

  1. Badawy

    Badawy Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Dear all ,

    please advice me how to write condition in ( bg absence formula ) to return HH:MM format on duration , how i can define hours on bg abence formula , my bg formula not allowed me to return hours and min in duration , just numbers , for ex when i creat new absence which his unit is hours from 11/11/2012 08:15 to 11/11/2012 12:00 , it returned 3.75 on duration , i want to able it to return 03:45 in duration .

    is there anyone can help me ??
     
  2. sivaramakrishna.d

    sivaramakrishna.d Active Member

    Messages:
    61
    Likes Received:
    6
    Trophy Points:
    160
    Dear Badawy,

    Can you send the code of your BG_ABSENCE_DURATION fast formula and functions used in fast formula to return the duration.
    i guess it is customised and duration calculation is wrong.

    Siva Ram
     
  3. diwaapps@gmail.com

    diwaapps@gmail.com Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    75
  4. UdayRaj Singh

    UdayRaj Singh Active Member

    Messages:
    4
    Likes Received:
    1
    Trophy Points:
    85
    Location:
    Australia