cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
Update: Find information on Dropbox support during COVID-19 here
Close

Dropbox files & folders

Get in sync with the Dropbox Community. Our users can answer all of your questions on files and folders. Join a discussion or start your own.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Highlighted

I have an issue with the displayed date and time in an Excel file. Any ideas?

New member | Level 2
New member | Level 2

I created simple excel file that displays date and time and put it to Dropbox.

I am in CET timezone, so locally I see 3. 10. at 7:50 in the morning.

When I open this via link in dropbox, it sets day to 2. 10. and time to 9:40 (I guess in the morning, as there is no AM, PM).

Does anybody know what is the exact timezone used by Dropbox?

Example:

https://www.dropbox.com/s/38eqw3pqelfcsq7/TIME.xlsx?dl=0

 

1 Reply 1

Re: I have an issue with the displayed date and time in an Excel file. Any ideas?

Dropboxer
Dropboxer

Hello @skrebl - welcome to the Community!

At first, can you clarify if you're inputting the date and time in your Excel file(s) using a DATE formula? Also, am I correct to assume that you're accessing the mentioned file via a shared link (as you said "When I open this via link in dropbox...") ? 

If the date and time appears to not match the time you would expect based on your timezone can you please perform the following steps:

1. Confirm that ‘Automatically detect timezone’ is checked on this page:

https://www.dropbox.com/account 

2. Confirm that the timezone of your computer is set correctly. 

If both are set correctly please provide the following information:

  1. A screenshot of your computer’s timezone setting
  2. A link to a file that has been recently modified, but that will not be modified while we investigate.

Thanks so much!



Walter
Community Moderator @ Dropbox
https://dropbox.com/support


Heart Did this post help you? If so, please give it a Like below.
Still stuck? Ask me a question!
Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.

Work Smarter with Dropbox

The way we work is changing. Share and discover new ways to work smarter with Dropbox in our community.

Sound good? Let's get started.
Need more support?