I am getting the unwanted time entries while importing the time entries from excel sheet (with cell type : Time). Than I found the reason behind this, it is happening because Business central fetch this time entry as an UTC time and than convert it into the time zone defined in the tenant settings. like my BC tenant has time zone UTC+5.30 so, it will add 5:30 hours in every time entry. which means if I add 01:00 AM it will consider it as 06:30 AM (01:00 + 05:30).
Can anyone help me to resolve this issue?
Hello,
Do you perhaps have some repro steps in standard? Are you working with BC OnPrem or in SaaS. How did you configure the time zone setting in My Settings of the WebClient and if OnPrem, how did you configure the Services Default Time zone?
How it is supposed to work is described here:
docs.microsoft.com/.../devenv-about-dates
Thank you.
Sohail Ahmed
2,725
Super User 2025 Season 2
Sumit Singh
2,610
Jeffrey Bulanadi
2,221