Office 365/Sharepoint中的Excel在今天/现在功能中使用哪个时区? [英] What timezone does Excel in Office 365/Sharepoint use for TODAY/NOW functions?

问题描述

当我使用TODAY函数在Sharepoint中处理Excel文档时，得到奇怪的结果.看来日期是从前一天开始.我想知道它使用哪个时区?这是一个设置吗?还是基于我使用的浏览器?

When working on a Excel document in Sharepoint when I use the TODAY function I get odd results. It looks like the date is from the day before. I wonder what timezone does it use? Is that a setting or is it based on the browser I use?

(上下文:我正在Kubuntu 20.04桌面上使用Sharepoint)

(Context: I'm using Sharepoint on a Kubuntu 20.04 desktop)

推荐答案

基于您在网站设置->地区设置中指定的时区.如下图所示:

That based on the timezone you specify in site settings->Regional settings. As the below picture shows:

这篇关于Office 365/Sharepoint中的Excel在今天/现在功能中使用哪个时区?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！