AnsweredAssumed Answered

Text field calculation from Timestamp field

Question asked by AnnetteSteinberg on Oct 27, 2011
Latest reply on Oct 27, 2011 by philmodjunk


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,