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?
Make your auto-entere calculation field a field of type Time or Number instead of text.