AnsweredAssumed Answered

Time Elapsed Calculation Pre/Post Midnight

Question asked by straka_sh on Sep 8, 2011
Latest reply on Sep 8, 2011 by 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...

 

Outcomes