3 Replies Latest reply on Sep 8, 2011 7:31 AM by straka_sh

    Time Elapsed Calculation Pre/Post Midnight

    straka_sh

      Title

      Time Elapsed Calculation Pre/Post Midnight

      Post

       We use FM for our time clock... one problem we are having at harvest time is some people start work before midnight and end shift after midnight but the calculation is always coming back strange.

      This is what I tried...

      ((Time Out 01 Calc + Time (24 ; 0 ; 0)) - Time In 01 Calc) - Time (0; 30; 0))

      For a person who punched in at 1:49 PM and punched out at 12:55 PM, the result is -13:23.

      The reason for the calculation would be (0 ; 55 ; 0) + (24 ; 0 ; 0) = 24;55;0 then subtract 13;49;00 to get 11;06;0 hours worked and subtract 30 minutes for lunch...