Level 1

32 points

Time zone and "NOW' Function

Hello, I live in a different time zone then where I work and I was wondering if someone could please advise as to how i can add +3 hours to the "NOW" function so that when I have my spreadsheet open it displays my work time not my local time. Thanks!

MacBook Pro 15", macOS 10.15

Posted on Apr 2, 2020 11:01 AM

Reply

Similar questions

Change time zone as automatically is dimmed I’m unable to change the time zone. It’s set to automatically change but it’s dimmed
1993 1
Auto Time change When I go into a new time zone my time changes as it should but when I come back to my time zone it does not. How can I fix this
392 1
Why can’t I Turn off Set Automatically on time zone? Why can’t I Turn off Set Automatically on time zone? It’s not allowed me to turn it off. What should I do?
872 1

2 replies

Apr 2, 2020 11:12 AM in response to 1234x

=NOW()+"3h"

Reply

Level 1

32 points

Apr 2, 2020 11:17 AM in response to Wayne Contello

Thanks!

Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Time zone and "NOW' Function

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up