shop-talk
[Top] [All Lists]

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

Subject: [Shop-talk] metric time - was OT- Excel help
From: fishplate at gmail.com (Jeff Scarbrough)
Date: Thu, 15 Mar 2012 20:39:05 -0400
References: <4F61A9BA.5030407@talktalk.net> <OF5E99C812.D08CAD37-ON852579C2.0042EA8C-852579C2.00437113@mail.megageek.com> <001e01cd02e9$82d057e0$887107a0$@rr.com> <4F626FBF.9040506@earthlink.net>
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.

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