[Shop-talk] metric time - was OT- Excel help

Roland Wilhelmy rwil at sbcglobal.net
Thu Mar 15 19:10:37 MDT 2012


anyone ever used or heard of the Julian date?
16 digits covers most anything you might need as accurately as you
might want.
-Roland

On Thu, 15 Mar 2012 20:39:05 -0400, you wrote:

::On Thu, Mar 15, 2012 at 6:39 PM, Brian Kemp <bk13 at earthlink.net> wrote:
::>  Then again, what about decimal time.
::
::In my job, I often have to make sense of time-based data that spans
::days or weeks.  The way we do this is to assign each data point a
::number based on the day of the year, plus a fraction representing the
::elapsed part of the 24-hour day.  Three decimal places is enough to
::represent minute-by-minute data, and pretty soon you learn to
::recognize that 62.25 is an early March day at 6:00 in the morning,
::while 185.875 is a good time to see some fireworks.
::
::I don't know if I want to live in that world all the time, though...
::
::Jeff Scarbrough
::Corrosion Acres, Ga.
::____________________________________


More information about the Shop-talk mailing list