Importing time measurements from MSExcel

When importing measurements with time from Excel, they must be formatted as a 5 character long text string and not as time. To reformat the existing time column follow these steps:

Create a new column; In the first data field of the new column write =Text( [original time field] ;“hh:mm“) e.g. =Text(C2;“hh:mm”)
Copy this cell (Ctrl+C); Select the whole column; Paste (Ctrl+V); Choose a name (free choice) for the new column; Before deleting the original time column, you first need to copy the newly create column, paste as values (right mouse click, paste special) and save .

The linked knowledge base article explains the steps in detail.

News headlines

28 October 2011 - News Training Course: GeODin, GIS and 3D-modelling in Geosciences The following course will be held in November at the Institute of Applied Geosciences of the Technical University in Darmstadt: "GeODin, GIS and 3D-modelling in Geosciences". Read more	22 June 2011 - News GeODin Ticket System In our efforts to continually improve the quality of our services, we have introduced a ticket system  to more quickly and more effectively help answer your enquiries. Read more
24 May 2011 - News Exporting more than 9998 boreholes New in the Knowledge Base: Exporting more than 9998 boreholes Read more	20 May 2011 - News GeODin Maps The Berlin local authority uses GeODin Maps for regional management of borehole, well and groundwater data linked to land parcels. Read more