[Top] [All Lists]

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

Subject: [Shop-talk] metric time - was OT- Excel help
From: rwil at (Roland Wilhelmy)
Date: Thu, 15 Mar 2012 18:10:37 -0700
References: <> <> <001e01cd02e9$82d057e0$887107a0$> <> <>
anyone ever used or heard of the Julian date?
16 digits covers most anything you might need as accurately as you
might want.

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

::On Thu, Mar 15, 2012 at 6:39 PM, Brian Kemp <bk13 at> 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.

<Prev in Thread] Current Thread [Next in Thread>