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
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
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"
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"
Thanks, I’ll give that a shot.
Displaying time zones in Apple Numbers.