Hi All, Another Question for you: if I try to import a cel that is formatted as time in excel into a time formatted field in a Navision Table, I get the message that Fin.EXE created errors. However, it works if i use a format like this : Time1 := FORMAT(xlSheet.Range(‘G’+Row).Value); Time1 is now a text field, containing 0,33333 how can i make this a timefield again, that contains the original 8 hours ? Thanks for your time again…
Maybe you could do this: Variables: Time1, Type Text Time1_Dec, Type Decimal Time1_Time, Type Time Time1 := FORMAT(xlSheet.Range('G'+Row).Value); EVALUATE(Time1_Dec, Time1); // Text 0,33333 is converted to Decimal 0,3333 Time1_Dec := ROUND(Time1_Dec * 24, 1.00); // 0,33333 day are 8 hours EVALUATE(Time1_Time, FORMAT(Time1_Dec)); // Decimal 8 to 8:00:00 Regards, Jörg
Must be that friday afternoon 
Thanks for explaining! Works like a charm…