1 Reply Latest reply on Sep 7, 2010 9:46 AM by philmodjunk

    Timesheet

    grocha

      Title

      Timesheet

      Post

      Created a time sheet. Having a proble with when i type in time as a pm time time it reverts back to am. It has a hard time calculating say

      In time:9PM

      Out time: 5AM

       

      Heres what i have.

      If (  not IsEmpty ( Time_End ) and Hour ( Time_End ) ≤ Hour ( Time_Start ) ; Time_End + Time ( 12 ; 0 ; 0 ) ; Time_End )

        • 1. Re: Timesheet
          philmodjunk

          Use a timestamp field instead of time. The timestamp field will include the date so that time intervals that start before midnight and continue after will compute correctly.

          TimeStampOut - TimeStampIn

          Will produce the elapsed time in seconds.