Re: Value of a date in Numbers
Re: Value of a date in Numbers
- Subject: Re: Value of a date in Numbers
- From: email@hidden
- Date: Wed, 4 Feb 2009 09:07:54 -0800
On MM in Numbers if I select Insert Date and Time from the insert menu
I get midnight for the current date, the insert time portion doesn't
seem to work, even if the cell is formatted to display time.
Michelle's remarks about dates in iCal point out something
important. Dates in iCal are associated with an event, which in turn
may be associated with a place, which is associated with a time
zone. You can store the date time information as UTC, but you must
also store the time zone info for the place of the event. When iCal
displays this info, it should display it in local time. No, not your
current local time, but the local time for the event. Imagine
traveling with a laptop while attending meetings in different
cities. If the displayed time is not for the time zone of the place
of the event, you will become very confused.
We do this all the time, coordinating conference calls in offices
across multiple timezone using Outlook, Blackberry's, Entourage and
iCal.
The dates are stored as GMT on all systems and displayed in local time
on all systems. As long as your laptop knows what time zone it's in,
you know when the call/meeting will be.
Still, we often remind people "That's 11 am in Chicago, noon in New
York and 5 p.m. in London"
Ed
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden