Displaying time zones in Apple Numbers.

Very simply put, I need to have 2 cells displaying time, 1 local, and the other GMT. I’m stumped. Any help is appreciated. Thanks.

iPad Pro, iPadOS 15

Posted on Jan 9, 2022 5:37 AM

Reply
Question marked as Top-ranking reply

Posted on Jan 9, 2022 5:53 AM

I don't think Numbers has access to the time zone, or at least it does not give that info to the user. If you know how many hours difference there is between your local time and GMT, add it to the time.


Five hours difference:

=NOW() + DURATION(,,5)


If you are collaborating with people across time zones I don't know what to do that would be "automatic"

2 replies
Question marked as Top-ranking reply

Jan 9, 2022 5:53 AM in response to WorkingSenior

I don't think Numbers has access to the time zone, or at least it does not give that info to the user. If you know how many hours difference there is between your local time and GMT, add it to the time.


Five hours difference:

=NOW() + DURATION(,,5)


If you are collaborating with people across time zones I don't know what to do that would be "automatic"

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.

Displaying time zones in Apple Numbers.

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