VERIFIED SOLUTION i

Summing time based data in MapInfo Pro

Products Affected: MapInfo Pro™
Finding the SUM of time columns in MapInfo Pro can be done through the MapBasic Window or SQL Select.

Through the MapBasic Window use the syntax (replace COLUMN_NAME with the name of your column and TABLE_NAME with the name of your table):

Select Sum(Hour(COLUMN_NAME)+Minute(COLUMN_NAME)/60) from TABLE_NAME into Selection

Alternatively, to use SQL Select refer to the window below:

User-added image
UPDATED:  October 4, 2019