VERIFIED SOLUTION i
X

How to create the SUM of time columns in MapInfo Pro

UPDATED: March 27, 2017


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

Downloads

  • No Downloads