If you need to know the number of hours elapsed between two time fields in a ClarisWorks database, use the following fields (field types):
StartTime (Time)
EndTime (Time)
ElapsedTime (Calculation, number result) = (EndTime-StartTime)*24
ClarisWorks stores the time fields as a percent of a day. Midnight is 0.0, Noon is 0.5, and 6:00 PM is 0.75. If two times are subtracted, you get the percent of a day between the two times. To convert this to a number of hours, multiply by 24 hours in a day.