Return to FileMaker.com
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
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 )
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.
Retrieving data ...