Duncan,
If you subtract two time columns, the result will be an integer in seconds Try this Set var v_start time = (.#time) Set var v_end time = (.#time) Set var v_time_used real = ((.v_end - .v_start) / 3600) Succes Tony ----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Walker Duncan Sent: zondag 20 juni 2010 17:22 To: RBASE-L Mailing List Subject: [RBASE-L] - Time Calculation I am currently using RBase 6.5++ for Windows and have a table to track events our volunteers work. One field is "StartTime" and another is "Endtime" (both are "Time" data type and HH:MM format). I wanted to create another field in the table that would calculate the hours . I tried by defining the field a data type time and created an expression [ Endtime-Starttime). However I get an error saying it is not the same data type. Can someone help me with this. Thanks, Duncan
