Format Time value in NAV 2013 on Excel-import

Desdemona667

Hello,
I'm having some trouble importing data from an excel-sheet via (custom) Report using the Excel Buffer table in NAV 2013.
Everything works as it should, except for time values. The value in the Excel Sheet is 13:30 (for example), but as soon as it is read into "Cell Value as Text" in the Excel Buffer, the value in NAV is 14:30. It makes no difference, whether the cells containing the time values in Excel are formatted as Standard or as Time.
I think this has something to do with the values from excel being formatted in NAV before they can be put in the Excel Buffer, but I'm not sure, whether this is general problem or just our’s. I have just tried changing my time zone to UTC (we’re UTC+1) and then the import ran correctly. Looks to me like NAV expects the imported time to be UTC and adjusts it for the actual time zone of the system. Can this be due to some error in config or settings?
As mentioned above: We only have this problem in 2013 (no matter if including RollOut3 or not), in 2009 it worked ok.
Does anyone have any experience with this? I'm looking forward to any input you can provide.
Thank you.

Cheers,
Marina

Edit:
I have also tried changing the timezone in CustomSettings to Server Time Zone (which is UTC+1) but this didn't help. The time imported is still the time given in the Excel Sheet + 1 hour.

Igor_Pchelnikov

Hello,
please check time on Service Tier.

Igor Pchelnikov

Desdemona667

Hey there!
Yeah, you're right, I forgot to mention that I tested the change of CustomSettings on my own local Service, so all three tiers are on the same machine - which uses UTC+1.
Cheers,
-Marina