1 Reply Latest reply on Oct 27, 2011 2:46 PM by philmodjunk

    Text field calculation from Timestamp field



      Text field calculation from Timestamp field



      I'm working on a Timecard database.  I have a calculation for total hours  from fields which use timestamps (time end - timein). I followed another post which indicated that if I wanted to have the total time calculation result be modifiable, I would use a text field, and use the auto-fill calculation function.  This works fine.

      I'm having problems with two additional fields which use the result of the calculated text field.  The first field calculates hours after 6 PM.  If the time out field is greater then 6 PM, then subtract time out from 6 PM. My calc is:

      If (Time_End pm > Time ( 18 ; 0 ; 0 ); GetAsTime (Time_End pm - Time ( 18 ; 0 ; 0 )))

      Next I  subtract my original Total time calculation (text) field - Hours after 6 calc. to get the difference.

      The two add'l fields are turning up odd results.  Can you please tell me what I need to change?

      Thank you,